Rename columns that are dynamic

[Syndicate_Admin]

Very good!! I get the data from a CSV by calling a url, but with the problem that that CSV can rename its columns from one day to the next, so I can't automate the normalization of the data in power query. The columns I get are of the type:
market, location, year, periodFrom, periodTo, total, airline:FR, airline:VY, airline:U2, airline:LS, ....., airline:OE, airline:X3, airline:KM

Those "airline" columns are the ones that can vary from time to time that the data is updated, and what I'm looking to do, without much success so far, is to automatically rename those columns and remove the "airline:" and keep only the airline code as a column.

Is it possible to do it??

Thank you very much in advance.

[amitchandak · Accepted solution]

@Syndicate_Admin , unpivot the column and split on : and pivot again if needed

https://radacad.com/pivot-and-unpivot-with-power-bi