Forum Discussion
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...
wdx223_Daniel
Community Champion
Community Championhope this can help
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)