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 ...