Re-arrange data set for mailing list

[gato88]

Hi appreciate if you could assist:

Current.PNG


Required.PNG


As the mailing list will grab the data under each header for each row (based on the customer number), I need to re-assign the data to the individual headers.
As per the sample above, the data will be sorted by customer number.
I have a long list of 500 customer numbers each with an average of 2 accounts, so I need to find an efficient solution to automate this task.

Appreciate your kind assistance. Thanks!

[candybg]

Where is the additional data required for your second data structure and how is it structured?
Maybe VLOOKUP or INDEX/MATCH would work.