In this tutorial, I will show you How To Transpose Or Convert A Single Column To Multiple Columns In Excel
DON'T CLICK THIS: ➡️ bit.ly/3sPIZvD
Link to download the exercise file: ➡️ bit.ly/3j92hay
Best Laptops to use for better speed:
1️⃣ amzn.to/3lf8zYU
2️⃣ amzn.to/3xejpAW
3️⃣ amzn.to/379OqeL
Best Equipment & Tools for KZitem Channel : ➡️ bit.ly/3inKa1P
There can be multiple ways to perform this trick, I will show you some of these in this tutorial now.
So, let us go to the 1st method:
1.Enter the formula in Cell C1 as =INDIRECT(ADDRESS((ROW($A1)-1)*3+COLUMN(A1),1))
2. Now let us see the 2nd way of doing this:
Using OFFSET Function
Enter the formula in Cell C1 as =OFFSET($A$1,COLUMNS($A1:A1)-1+(ROWS($1:1)-1)*3,0)
3. Now let us see the 3rd method of doing this by VB Code:
➡️ VBA Code:
Option Explicit
Sub movetocolumns()
Dim i As Integer, iRow As Integer
Dim arrSource As Variant
'Set the first row
iRow = 1
With ActiveWorkbook.Worksheets("Sheet1")
'get the data into an array from the first column
arrSource = Range(.Cells(1, 1), .Cells(.Rows.Count, 1).End(xlUp))
'parse every value of the array and add the data to the next column
For i = 1 To (UBound(arrSource) - UBound(arrSource) Mod 3) Step 3
.Cells(iRow, 3) = arrSource(i, 1)
.Cells(iRow, 4) = arrSource(i + 1, 1)
.Cells(iRow, 5) = arrSource(i + 2, 1)
iRow = iRow + 1
Next i
'add the remaining values
Select Case UBound(arrSource) Mod 3
Case 1 'one item to add
.Cells(iRow, 3) = arrSource(i, 1)
Case 2 'still two items to add
.Cells(iRow, 3) = arrSource(i, 1)
.Cells(iRow, 4) = arrSource(i + 1, 1)
Case Else 'nothing to add
End Select
End With
End Sub
Now go back to the excel sheet and from the view tab, click on view macros and run the macro called “movetocolumns”
That’s it friends.
Our Recommendations
***************************************************************
Oracle Primavera Tutorials : bit.ly/3fn9PFH
Microsoft Excel Tutorials : bit.ly/2V5de5l
Microsoft Project Tutorials : bit.ly/37guNl7
For Personalized detail learning, write to dptutorials15@gmail.com
If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later.
***********************************************
★ My Online Tutorials ► www.dptutorial...
⚡️LEARNING RESOURCES I Recommend: www.dptutorial...
⚡️Subscribe for more Awesome Tutorials: goo.gl/NyAtg2
⚡️Support the Channel via shopping: amzn.to/2ZRfTOZ ift.tt/2jH38PR
⚡️Tools for KZitem vlogging:
***********************************************
• Laptop: amzn.to/2CaLFxJ
• Canon 200D Camera: amzn.to/3d7jDR4
• Benro Tripod: amzn.to/3exQoax
• Microphone: amzn.to/3c5lEvS
• Collar Microphone: amzn.to/2X8DWrS
• Screen recorder: techsmith.pxf....
• Boom Arm Stand: amzn.to/3extb87
• Zoom H1 Audio Recorder: amzn.to/2TNdHFj
• Harison Softbox Studio Lights: amzn.to/3caGbzg
• Chroma Key Green Screen: amzn.to/2M60mn4
• Background Support Stand: amzn.to/3dbACSv
• Acoustic Foam Background: amzn.to/3gzFtyC
• USB RGB LED Strip: amzn.to/36BpCLF
• Wireless Mouse: amzn.to/2TPIrW7
***********************************************
⚡️You Can Connect with Me at:
***********************************************
KZitem: / dptutorials
Instagram: / dptutorials
G+: ift.tt/2kAOpa6
Twitter: / dptutorials15
Facebook: ift.tt/2kfRnDi
BlogSpot: ift.tt/2kB14dh
Websites: www.dptutorials... & www.askplanner....
#dptutorials #Exceltraining #ExcelTricks #ExcelTips #ExcelFreeTraining #ExcelFreeLearning
⚡️Tags: -
1 column,one column,multi column,Into,dptutorials,tutorial,how to convert column to row in excel,leila gharani,Convert A Single Column To Multiple Columns,How To Transpose Or Convert A Single Column To Multiple Columns In Excel,single column to matrix in excel,single column into a table in excel,column into array,transpose single column into multiple rows,convert single column into,one column to multiple columns in excel,single column to multiple columns excel
Негізгі бет How To Transpose Or Convert A Single Column To Multiple Columns In Excel || dptutorials
Пікірлер: 184