splitting column to remove hierarchy in indented rows

[davidm58]

HI I have a csv file with the below layout and am trying to use power query to create a new set of columns so that it looks something like the second table, so i can then merge the two columns, I've tried transposing and pivoting but nothing seems to work! Any tips appreciated, thanks

MP at consulting room	32.60%
Attendance	5.77%
Attendance < 20mins	100.96%
Attendance > 20mins	73.08%
Attendance > 40mins	41.35%

MP at consulting room	MP at consulting room	32.60%
MP at consulting room	Attendance	5.77%
MP at consulting room	Attendance < 20mins	100.96%
MP at consulting room	Attendance > 20mins	73.08%
MP at consulting room	Attendance > 40mins	41.35%

[davidm58]

sorry the table has changing rows, eg: so i need the new column to change as well 

i tried to edit the post but couldnt work out how

. 

MP at consulting room	104
Attendance	6
Attendance < 20mins	105
Attendance > 20mins	76
Attendance > 40mins	43
MP not at consulting room	0
Attendance	0
Attendance < 20mins	0
Attendance > 20mins	0
Attendance > 40mins	0

[FreemanZ]

just add a column with content of "MP at consulting room" or?

[davidm58]

ah sorry, i didnt make it at all clear that the 'MP at consulting '  then changes, will update now