Power Query - get first column name in a new column named "Ticker"

[Lars Ole Sørensen]

Hi,

I want in power query to extract the first column name and place it in a new column named "Ticker". This is shown in the attaced excel document via excel formula in column L.

Thanks in advance for any help

Regards
Lars Ole

 

[Chihiro]

Add custom column after "Changed Type" step.

=Table.ColumnNames(#"Changed Type"){0}

 

[Lars Ole Sørensen]

Fantastic, works like a charm. Chihiro, thank you very much for the assistanse