Forum Discussion
PBE
2 years agoHelper II
Excel Data Manipulation & Power BI
Hi I download an Excel workboot and it has a number of sheets in it all in the same format. In power query I know how to extract the data in rows 6 to 10 and combine the sheets. The person's...
- 2 years ago
Hi I've subsequebtly realised this isn't necessary as when loading workbook into power bi the 1st column contains the sheet name.
PBE
2 years agoHelper II
Hi I've subsequebtly realised this isn't necessary as when loading workbook into power bi the 1st column contains the sheet name.