Split one long column into multiple smaller columns in Excel

Question asked often in forums

What is the best way to copy paste in groups of 15 items if you have a list of over 7000 items? If anyone has a better method than the following, please let me know 

I have a long list of 7000 items from column A1 to A7000. I would like to split this up into different columns (B,C,D...etc) in groups of 15. In other words, how do I make column:

B1:B15 include items A1:A15. 

C1:C15 include items A16:A30. 

D1:D15 include items A31:A45 etc... 

Any help is appreciated. Thank you!


try the file in this example. The raw data is in a sheet you would have renamed "rawdata"

Split one long column into multiple rows

 Other excel answers



You can find similar Excel Questions and Answer hereunder

1) Split string into multiple columns in Excel

2) How to rename multiple sheets easily with VBA

3) How can I convert Column numbers into Column names for use in range definition?

4) Autofill a b c d aa ab in Excel

5) How to disable ability to insert Rows and Columns in Excel (using VBA)?

6) how do you enter multiple line in a cell in Excel

7) How can I find the least common multiple using Excel?

8) How to find the cell address from the column number in VBA

9) How do you know which column was used last, Here the explanation to find it with VBA

10) Vlookup to return multiple values in same cell in Excel


Here the previous and next chapter