copy column to other query

[Nelleke-NL]

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	answer2	q1	q2
Anna	nee	administratie	1;2;3	1,2,3,4,5
Bertha	nee	schuld	1;2	1,4,5
Cor	ja	schuld	1;3	1,2,5
Dennis	nee	administratie	2;3	2,3,5

Now I have to make for each multiply answer in a column different downloads. So I have table complete, table q1, table q2

But is it possible and how, to make a copy of the column Name en column q1 to a different table and also for column Name en column q2. Then I make there the steps for listing the answers and count it in a report. 

Please help me, I'll be greatfull!

[wdx223_Daniel]

hope this can help

[Nelleke-NL]

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)

[AlB]

Hi @Nelleke-NL 

Can you show the expected result? I don't quite understand the requirements from your explanation

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[Nelleke-NL]

I'll try *English is difficult for me

= Table.AddColumn(#"Type gewijzigd1", "Q1 new", each Text.Split([q1],";"))

= Table.AddColumn(#"Aangepaste kolom toegevoegd", "Q1 new", each Text.Split([q1],";"))

= Table.AddColumn(#"Aangepaste kolom toegevoegd", "Q2 new", each Text.Split([q2],";"))

Removed Q1 and Q2

= Table.ExpandListColumn(#"Kolommen verwijderd", "Q1 new")

report:

Huh How can I count like Q1 new? Other tabel? Or is there a nicer solution?