I have a report that exported from our accounting software, unfortunately the
report exported in a vertical format, so the headings are in Column A and the
data is in Column B.

I need to move the headings horizontally (A1, B1, etc) and then have the
data in Column B, associated with the headings in Column A, move to the
correct column. For example:

The report currently looks this way.
Customer Number XXX
Customer Name: XXXXX XXXXX
Address: XXX XXXXXXX
City: XXXXXXX
State: XX
Zip Code: XXXXX

I need it to look like this
Customer Number Customer Name Address City State Zip Code
XXXXX Xxxxxxx