How do I copy columns from multiple sheets into a new sheet?

Question

Hello,&nbsp;I'm trying to figure out how to do something that seems relatively simple, but I can't figure it out. I have two Excel sheets that contain my source data, and I'd like to use Power BI to copy a couple columns from each of the sheets into a new table in which I can perform manipulations.&nbsp;&nbsp;Here are examples of my source tables:&nbsp;Source Table 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Source Table 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Output Table:Copy columns 1-2 in table 1 and columns A-B in table 2 into output table.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;The goal is to make it so that whenever updates are made to the source sheet, all I have to do is refresh Power BI to see my changes reflected in the new table.&nbsp;&nbsp;Thanks in advance for your help!!&nbsp;

anonymous · Accepted Answer

Anonymous&nbsp; - Is there any relationship between the 2 sheets? If it's simply mapping the same row on each sheet, you could do the following in Power Query:

Import both tables
Add an Index column to both tables
Merge one table into the other, joining on the Index columns.
Expand columns.
Remove any unnecessary columns

I hope this helps. If it does, please Mark as a solution.I also appreciate Kudos.

Forum Discussion

How do I copy columns from multiple sheets into a new sheet?

2 Replies

Related content

Google sheets

Filter Multiple Sheets with Common Column

Sequential Order column based on multiple criteria

Multiple line and clustered columns chart

Import multiple files with multiple sheets from folder