In this tutorial, I will show you How To Transpose Or Convert A Single Column To Multiple Columns In Excel

DON'T CLICK THIS: ➡️ https://bit.ly/3sPIZvD
Link to download the exercise file: ➡️ https://bit.ly/3j92hay

Best Laptops to use for better speed:
1️⃣ https://amzn.to/3lf8zYU
2️⃣ https://amzn.to/3xejpAW
3️⃣ https://amzn.to/379OqeL

Best Equipment & Tools for YouTube Channel : ➡️ https://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 : https://bit.ly/3fn9PFH
Microsoft Excel Tutorials : https://bit.ly/2V5de5l
Microsoft Project Tutorials : https://bit.ly/37guNl7

For Personalized detail learning, write to [email protected]

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 ► https://www.dptutorials.com

⚡️LEARNING RESOURCES I Recommend: https://www.dptutorials.com/resources

⚡️Subscribe for more Awesome Tutorials: http://goo.gl/NyAtg2

⚡️Support the Channel via shopping: https://amzn.to/2ZRfTOZ http://ift.tt/2jH38PR

⚡️Tools for YouTube vlogging:
***********************************************
• Laptop: https://amzn.to/2CaLFxJ
• Canon 200D Camera: https://amzn.to/3d7jDR4
• Benro Tripod: https://amzn.to/3exQoax
• Microphone: https://amzn.to/3c5lEvS
• Collar Microphone: https://amzn.to/2X8DWrS
• Screen recorder: https://techsmith.pxf.io/2BMjA
• Boom Arm Stand: https://amzn.to/3extb87
• Zoom H1 Audio Recorder: https://amzn.to/2TNdHFj
• Harison Softbox Studio Lights: https://amzn.to/3caGbzg
• Chroma Key Green Screen: https://amzn.to/2M60mn4
• Background Support Stand: https://amzn.to/3dbACSv
• Acoustic Foam Background: https://amzn.to/3gzFtyC
• USB RGB LED Strip: https://amzn.to/36BpCLF
• Wireless Mouse: https://amzn.to/2TPIrW7

***********************************************

⚡️You Can Connect with Me at:
***********************************************
YouTube:    / dptutorials  
Instagram:   / dptutorials  
G+: http://ift.tt/2kAOpa6
Twitter:   / dptutorials15  
Facebook: http://ift.tt/2kfRnDi
BlogSpot: http://ift.tt/2kB14dh
Websites: http://www.dptutorials.com & http://www.askplanner.blogspot.com

#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