Christmas card address fiasco

[Anonymous]

You are not going to believe this but somehow we lost all our Christmas card addresses.

Actually we just lost them in excel.  We still have them in word.

Now I am trying to put 150 addresses back into Excel.  Like a reverse mail merge. Without copy and pasting myself to death.

What do I need to do in Power Query Editor to take the addresses in these rows and put into columns?

Here is where I am at so far - and now I am stuck.

Sample Data:

https://docs.google.com/spreadsheets/d/1NJ6iNbKn0AJUI2K2GpaVYsp_sgWLONVvJTfEfWEmrI4/edit?usp=sharing

[v-yuta-msft]

Hi twb311,

Have you solve your issue by now? Could you kindly mark my answer to finish the thread?

Regards,

Jimmy Tao

[v-yuta-msft]

Hi twb311,

In your sample data, your requirement is to add rows to your original table, right? So where's your lost data? To be general, you can export yout data to sql server and then import the lost data table into power bi, then append the lost data table and original table.

Regards,

Jimmy Tao