Need FAST Help! Consolidate multiple rows into columns for 38k lines. Complex problem!

[Emajen]

Greetings,

Here is my situation. I need to take a list of customer accounts and sort the information to a specific template that I can import to our new website. However the way the data is presented makes that difficult...

Every address saved for 1 customer is a separate line. So if you have a different billing or shipping address it would be 2 rows. Sometimes 3 rows. I need to move those rows into a column (Address 1, Address 2, etc.) under 1 row. So if CustomerA has 3 saved address, I need to take those 3 rows and move them into 3 columns of 1 row. I hope that makes sense.

I have no idea if a formula, pivot table, or VBA(I know as much as Jon Snow in this area) would be the best route to take. I tried pivot tables, but it's not really working out. I was thinking Index/Match might be the best solution - I'd just have to duplicate the formula for each Address column, but it'd get the job done. However I don't know how I can accommodate for the multiple rows.

Attached is an example of the data I received. Line 20 is the template I need to move the rows into. Column g_user id is unique per customer, but with multiple rows of addresses for a single customer that value will be duplicated in the spreadsheet. Same with customer_no.

Please let me know if you need more information and I will try to explain further.

Thanks for any help you can provide,

Brad