I have large Excel table, many rows data in one column, representing data fields, repeated for each data record. e.g.: like so:
DATA
john
town1
22345
stan
town2
45690
edith
town3
56129

Many such rows. The same pattern repeats. I do not have the field name and record numbers in the form;
field record no DATA
a 1 john
b 1 town1
c 1 22345
a 2 stan
b 2 town2
c 2 45690
a 3 edith
b 3 town3
c 3 56129


I need a macro to convert such data into columns each representing data fields.
The result desired:
record no/field> a b c
1 john town1 22345
2 stan town2 45690
3 edith town3 56129

Pl. note that there may be hundreds of records and many data fields.
Need a macro where record number is 1 to i, and data field, 1 to j.