How do I move rows into columns

I have a text file with rows of data. I want to take every 4 rows and move them into columns:

row 1 → output row 1, column 1

row 2 → output row 1, column 2

row 3 → output row 1, column 3

row 4 → output row 1, column 4

row 5 → output row 2, column 1

row 6 → output row 2, column 2

row 7 → output row 2, column 3

row 8-> output row 2, column 4

etc

How can I do this. I couldn’t see how pivot or transpose could do this.

Thanks

then write out to excel…