Data in 1 column and I need to get the data in multiple columns

[kellyforde86]

Hi there

I hope you're well. I'm looking for some guidance on if this is possible and how I would do it if it is.

Currently all my data is in 1 column with 28,000 rows.

A2 : Field 1
A3 : Field 2
A4 : Field 3
A5 : Field 4
A6 : Field 5
A7 : Field 6
A8 : Field 7
A9 : Field 8
A10 : Field 9
A11 : Field 10

Then the data repeats.

Is there any way as the data repeats in a set order I can make Rows A2:A11 become columns and then that repeated for each repetition?

Thanks
Kelly

[AliGW]

Are you still using Office 2016?

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

[HansDouwe]

If you are updated to Excel 365, please try

Please Login or Register  to view this content.

[HansDouwe]

If you are still using Excel 2016, please try and copy right and down:

Please Login or Register  to view this content.

See attachment with solution Post #3 and #4