Ok, so I have a spreadsheet that has data pulled from another program. The data essentially displays like this:
Column A=Customer Name
Column B=Text Description
Column C=Category Name
The data shows the same customer on multiple lines if they have multiple ads with us, so the data could display in the rows like this...
1. Customer A
2. Customer A
3. Customer B
4. Customer C
5. Customer C
6. Customer C
7. Customer D
8. Customer E
9. Customer F
10. Customer G
Anyway, I need to do two things.
1. Export all the customer data into individual Excel files. One for each unique customer in Column A (I did this already via macro)
2. Upon exporting to all the individual files, reformat so that it looks prettier (This I can't figure out)
Essentially what I want to do is have Column A as a header of a table in each individual excel file that is created, and the Column C & Column B beneath. So merge all the duplicates of Column A into a header of a table when exported, and then list all the ID #'s (Column C) and their accompanying descriptions (Column B)
I'll do a quick paint rendering if that needs to be clarified.
I drew this in paint to illustrate what I want.
I also drew a robot, who is there to point out what it is I want.. As you can tell, he's happy to be able to participate.