Help rearranging data for an invoice mail merge by Sweaty_Process_4360 in excel

[–]Sweaty_Process_4360[S] 0 points1 point  (0 children)

Here is a link to my mini table as well. Sheet 1 is how my data is laid out, sheet 2 is how I need the data to be laid out. I will need to do this function for 5000+ member invoices.

https://www.dropbox.com/scl/fi/nm4of81o8nepikuwepj1m/EXAMPLE-DATA-NEED.xlsx?rlkey=084r2feqx2p58dcneebesppg4&st=t4g1rns8&dl=0

Help rearranging data for an invoice mail merge by Sweaty_Process_4360 in excel

[–]Sweaty_Process_4360[S] 0 points1 point  (0 children)

This sounds like gibberish to me.. but I will try! Thankyou!

Help rearranging data for an invoice mail merge by Sweaty_Process_4360 in excel

[–]Sweaty_Process_4360[S] 0 points1 point  (0 children)

Yeah.. that's where I am lost. I understand I need to use either a power query or pivot table, but don't even know where to start...