Sales History Report

[edsjr]

I have a report that has the customer name at the top then below it items they bought and then an empty row, another customer and items they bought. I need to move the customer name to column A so it's in the same row as the item number. I have about 550 customers in this report. How can I do this?

I can't post attachments but here is a link to a sample spreadsheet in my onedrive account. The top section is how the data i currently formatted and the bottom is how I need it formatted.

https://1drv.ms/x/s!AlMKyRBHlUsBgawHWo8LLapoIIRucw

Thank You in Advance!

Ed.

 

[edsjr]

Doing this on another spreadsheet, in this case I need the (11) to appear in column A....I can remove the parenthesis after the fact. What am I doing wrong?

Link to file on OneDrive

https://1drv.ms/x/s!AlMKyRBHlUsBga5uZjnlQ3jpTb0qCg

Thank You!