Excel Data Manipulation & Power BI

[PBE]

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 name is in cell A2 or the sheet name. The part I don't know is how to create a column containing the person's name using power query.

The desired result being:-

Thanks in advance

PB

[PBE · Accepted solution]

Hi I've subsequebtly realised this isn't necessary as when loading workbook into power bi the 1st column contains the sheet name.