Converting data from GP Dynamics to Excel

Question

I saved data from GP Dynamics as a .cvs file and imported it to Excel.

I need to separate the headings and the data  in separate columns. Right now they are all in one row (see below sample)

Vendor    Vendor Check Name   Tax ID       10 Amount
10  Address                                 City                State    Zip Code

0      Mr. Smith                    0x0-2x2-2x3            $2000.00
#8 Earth xx.                      Planet                    xxx Way 02x

Thank you

Answer 1

Dear Power,

Welcome to share any updates when you have time if you need further help on this issue.

Best Regards,

Cliff

Answer 2

Hi,

Share the download link of your file and show the expected result in another tab of that file.

Answer 3

It looks like they did a bad job of creating the CSV file. You could use Find and Replace - Find 3 spaces, and replace with a character like @ that does not appear in your data anywhere - then use the @ as the delimiter  in text to columns. Then you will need to rearrange the values using extra columns of formulas like this in cell E1, copied to F1:H1

=TRIM(A1)

and this in cell I1, copied to J1:L1

=TRIM(A2)

Then you need to copy those formulas to move all the second rows of each block of data up - it is hard to tell from your example if there are two or three rows...so I can't be as specific as you may need. If there are no extra blank rows between rows, copy F1:L2 and paste it into an even number of rows starting at F3 and matching your data.

I'm sure your will need to do more clean up that that will get you started.