Merge or Append... not sure which to use and how to use it...

[sharpedogs]

Hi, 

I have a single excel file with 50 tabs. Each tab represents some Server Silo Data. Each tab has the same 4 peices of data. I want to simply merge all the tabs into one large single table. And in the process only have one header, something alone the lines of a merge all tabs and remove the top row from all tabs except the first?

Any help would be appreciated.

[artemus · Accepted solution]

1. Load in any 1 tab of your excel file

2. delete all the steps in the query editor except the first

3. Remove all columns except Data

4. In the Data column, click the Expand button. Uncheck the use origional name as prefix. Then click ok.

[dax · Accepted solution]

Hi sharpedogs,

Did you mean that you a Excel which have many sheets in it, and in each sheet, the header are all the same? If so, you could load all sheet in power bi , then use "Append Queries", then it will combine into one.

Best Regards,
Zoe Zhi

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

[artemus · Accepted solution]

1. Load in any 1 tab of your excel file

2. delete all the steps in the query editor except the first

3. Remove all columns except Data

4. In the Data column, click the Expand button. Uncheck the use origional name as prefix. Then click ok.