Forum Discussion

Nelleke-NL's avatar
Nelleke-NL
Icon for Helper II rankHelper II
3 years ago

copy column to other query

I'm very glad with the solutions to work with answers on multiply answer-question previous question    But in the complete table there are several columns/questions like this.  Name  anwers a...
Need Help
Show and Tell
Tips and Tricks
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
3 years ago

hope this can help

 

Nelleke-NL's avatar
Nelleke-NL
Icon for Helper II rankHelper II
3 years ago

Almost....

 

= Table.AddColumn(#"Headers met verhoogd niveau", "Aangepast", each Table.ExpandListColumn(Table.TransformColumns(Table.UnpivotOtherColumns(Bron{[Item="Blad1",Kind="Sheet"]}[Data],List.FirstN(Table.ColumnNames(Bron{[Item="Blad1",Kind="Sheet"]}[Data]),3),"Q","Value"),{"Value",each Text.SplitAny(Text.Trim(_),";")}),"Value"))

little problem with first 2 row. Maybe something I can fix?

 

 

 

 And to test in the big tabel.  I need to understand where the formule the link is to the right column

My table has a lot of columns. How can I select the right columns? (hulpvraag + probleemstelling + reden niet in behandeling)