You guys have come through for me before…
So I have the data in excel as complete records, almost 2500 of them, and each record is composed of 33 fields.
It now is assembled thusly:
[ol]
[li]RECORD one [/li][li]name joe[/li][li]address usa[/li][li]phone 758[/li][li]favorite food burgers[/li][li]hair color brown[/li][li]computer PC[/li][/ol]
[ol]
[li]RECORD TWO [/li][li]name bill[/li][li]address japan[/li][li]phone 9273[/li][li]favorite food rice[/li][li]hair color green[/li][li]computer MAC[/li][/ol]
[ol]
[li]RECORD THREE [/li][li]name joe[/li][li]address Brazil[/li][li]phone 99999[/li][li]favorite food beans[/li][li]hair color blonde[/li][li]computer PC[/li][/ol]
[ol]
[li]RECORD FOUR [/li][li]name Mary[/li][li]address usa[/li][li]phone 8273[/li][li]favorite food burgers[/li][li]hair color blonde[/li][li]computer Mac[/li][/ol]
And I want it to be this:
**Record Num name address phone food hair computer**
Record One joe usa 758 burgers brown PC
record two bill japan 9273 rice green MAC
record three joe Brazil 99999 beans blonde PC
record four Mary usa 8273 burgers blonde Mac
This is such standard stuff I know there must be a way. I just can’t figure it out.
Help!