Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Must all of the worksheet names in a file be the same? I did a test and noticed that when worksheet names are different I get an error.
Solved! Go to Solution.
Probably depends on your Navigation step. Take a look at this:
https://www.excelguru.ca/blog/2014/11/19/combine-multiple-worksheets-using-power-query/
You should be able to use this technique to access the same sheet number (1st, 2nd, 3rd)
Probably depends on your Navigation step. Take a look at this:
https://www.excelguru.ca/blog/2014/11/19/combine-multiple-worksheets-using-power-query/
You should be able to use this technique to access the same sheet number (1st, 2nd, 3rd)
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |