Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

Hello,   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 c...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Anonymous  - 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:

    1. Import both tables
    2. Add an Index column to both tables
    3. Merge one table into the other, joining on the Index columns.
    4. Expand columns.
    5. Remove any unnecessary columns
    I hope this helps. If it does, please Mark as a solution.
    I also appreciate Kudos.
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous  - 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:

  1. Import both tables
  2. Add an Index column to both tables
  3. Merge one table into the other, joining on the Index columns.
  4. Expand columns.
  5. Remove any unnecessary columns
I hope this helps. If it does, please Mark as a solution.
I also appreciate Kudos.
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks a ton, worked like a charm!