Log In
Register
Home
New Member
October 30, 2020
Offline
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
1 Guest(s)
