Excel Expert
Budget: $10 – $30 AUD
In the Excel sheet, I've indicated in K1:AE1 what I'd like the outputs to be. I've filled them for a couple of different entries as examples to see where in the text strings the values should be pulled from. Ideally at the end, all the multiple-rowed entries in each of the data globs would be displayed as single rows in a master list.