Hi, I've got a report which returns number of seats booked in each class as one column, delimited by a comma space, e.g.
E-2, G-17, N-1, Q-1, V-1, X-1. This varies by what classes were booked on that particular flight, i.e. they're always ordered alphabetically, but not all are present as per attached example.
Currently I have to use Data to Columns (split by delimiter), then sort each resulting column by the letter code, move to appropriate column and then replace all E- G- N- etc. by nothing, to get the number of booked seats for each class.
I am very new to Power Query and am trying to figure out if/how I can get it to do this for me. I have tried to write some IF formulas in the advanced editor, but without luck so far.
ETA: I'm using MS Office 365
I think I have figured it out, using Add Column from Examples, and then tweaking the script to change the delimiter to each class (e.g. E-, G- etc.)
Hi Katerina,
If you get stuck just let us know.
Regards
Phil
