Hi,
I have data like this
Data in Row 1 (one value per cell)
1 2 3 4 5 6 ....................32
I want to split data in each row into 8 rows. i.e. after the split each row should contains 4 values. The output should be like this
1 2 3 4
5 6 7 8
9 10 11 12
13 14 15 16
.
.
.
29 30 31 32
I have data in 100 rows thus the output should be 1 row split in 8 rows x 100 = 800 rows
Thanks in advance.
Bookmarks