Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Merging data from multiple sheets in PowerBi

I have a workbook with several sheets that all have the same table layout. I want to combine these tables into one, but I also want to preserve the sheet names as labels for each section of the merge...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

     

    After connecting to the data source, click "transform data" to enter the power query.
    For the s1 table, add a custom column.

    Merges the column with the type column.

    Repeat the same steps to add custom columns to the s2 and s3 tables and then merge them.

    Then append these three tables.

    Then the result is as follows.

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Unfortunately, I can't provide a sample. Here's the detailed explanation: I have an Excel file with sheets named S1, S2, S3, S4, and so forth. All these sheets have the same table structure, meaning they have identical columns but different rows. I'm trying to merge the data from these sheets into a single table. To distinguish between the tables, I want to use the sheet names as IDs

lbendlin's avatar
lbendlin
Super User
2 years ago

I cannot assist you if you are unable to provide sample data. I hope someone else can help you further.