cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
twb311 Frequent Visitor
Frequent Visitor

Christmas card address fiasco

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

2 REPLIES 2
Community Support Team
Community Support Team

Re: Christmas card address fiasco

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

Community Support Team
Community Support Team

Re: Christmas card address fiasco

Hi twb311,

 

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

 

Regards,

Jimmy Tao

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 6 members 3,690 guests
Please welcome our newest community members: