How To Transpose Or Convert A Single Column To Multiple Columns In Excel || dptutorials

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

Best Laptops to use for better speed:

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
***************************************************************

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.

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

⚡️Tools for YouTube vlogging:
***********************************************

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

⚡️You Can Connect with Me at:
***********************************************

#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

[ridhimabhatia.bhatia]

I want to thankyou from the bottom of my heart for not only making this video but also sharing the formula in the description box of the video. As I have seen other videos where youtubers show the formulas & VBA codes as to be written to run the macro but don't give it in the description box. You have really made my life simpler by sharing the formula in the description & it worked for me. You have saved quite a few hours of mine due to this as I had 336 rows data to be converted to columns width of 10.

[juliejoy]

Thank you so much. You and this tutorial saved our days. I lost almost one day in searching for ways to do this task with no hope. One of my friends accidentally came across this and shared with me. This is just awesome. Thank you!

[fabiandonvil]

thank you. the visual basic method was just the thing i needed.

[jsnuk]

BRILLIANT Thanks very much for posting three different options, with such clarity. (The second one worked for me.) I came to this video from your other one which was the reverse. It was very helpful that the two videos were linked. You saved me an enormous amount of time, as I couldn't find this explanation anywhere else.

[Katie-]

THANK YOU!! I tried other videos and for some reason they didn't work. yours did and was VERY easy to follow. GREAT WORK!! :D

[qualityquest]

Thank you sir, for sharing such a Valuable information, this I was looking exactly to distribute single column data to multiple column and rows.
Thanks for Superb explanation.

[souradeepdas]

Thank you it saved a lot of time. Special thanks for sharing the formula in the description box of the video. VBA codes is absolutely perfect.

[rafaqataudit]

Very good video. THANK YOU, dptutorials! you saved us a LOT of time!

[GiancarloP]

Thank you so much for this!

Is there any way to tweak the formula so that the values are copied in order from top to bottom instead from left to right??

[ravindra]

I am looking for this trick from many days finally I got it.

[minagolazad]

I don't know how to thank you. This was the most helpful video. Man, you saved me!

[fekrabusinesssolutions]

Works 100%. Thank you for the great ideas.

[hannahnguyenanhtho]

thank you so much. This video is really useful.

[vishalguitar]

btw, very helpful and clearly explained the output.

[henryutila]

Hi I like the video tutorial very much. Thank you for showing

[darioandreozzi]

how do a I get the order to be vertical instead of horizontal? I want get 6 columns from the long one I have but keep vertical order of numbers and not horizontal like in the video!! please help

[nzr]

You are awesome. this saves a lot of time.

[ArmanKhan-iqji]

Thank you bro, U make my work so easy 🙂

[farhanhabiburrahman]

Thanks a lot, it's really help me doing statistics task

[oLuii]

Indian guy making my life so much easier <3
You should consider putting donation information on your description, I would actually tip you, because you saved me so much time and effort