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