My inability to find a solution discussed previously is likely due to not searching the right key words; however this problem certainly has been discussed prior in the forum and the solution may be simple.

Convert the following example columnar data to rows whereas A,D and G data are under the same heading as are B,E and H - etc,. I would use transpose; however there are 1000 records in the column.

Data Example

A
B
C

D
E
F

G
H
I

Desired result

A B C
D E F
G H I