Need help filling in a table horizontally from a long string of data

[BentotheJJ]

New to the forum so hopefully I am posting in the proper section. Basically what I am doing is copying and pasting a long string of data that has been outputted from my PLC into a spreadsheet and attempting to organize the data into a table. The problem I am having is this needs to be filled horizontally, or vertically in multiples of 5. Example:

Data comes in like this:
1
2
3
4
5
6
7
8
9
10

I need it to be organized like this:
1 2 3 4 5
6 7 8 9 10

Up to around 1500 data points. Is there an easy way to make this automatically as soon as the data is copied into the spreadsheet? Any help is greatly appreciated.

[FDibbins]

If your data is in column A starting in A1, down, create a table next to it (I started in C1)

In D1:H1 enter 1, 2, 3, 4, 5
in C2:C10 enter 1, 2, 3, 4 etc (extend the range as needed.)

Then in D2, copied down and across, use this...
=OFFSET($A$1,(D$1-1)+($C2*5)-5,0)

[BentotheJJ]

Thanks! worked perfectly.

[FDibbins]

Happy to help and thanks for the feedback