Forum Discussion
splitting column to remove hierarchy in indented rows
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 ...
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 |