I get a spreadsheet of records all in one long row. I need each record in a row with each part of data in a separate column.
For instance, would like to change this:
Nickname
Contact name
Packaging
Weight
Service type
13
Branch Manager
FedEx Envelope
1 lbs
FedEx 2-Day
30
Branch Manager
FedEx Envelope
1 lbs
FedEx 2-Day
into this:
Nickname Contact name Packaging Weight Service type
13 Branch Manager FedEx Envelope 1 lbs FedEx 2-Day
30 Branch Manager FedEx Envelope 1 lbs FedEx 2-Day
Is there an easy way to do this besides copy and pasting/transposing one at a time? There are hundreds of separate records.
Thanks!
Bookmarks