copy column to other query

Question

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!

alb · Answer

Hi Nelleke-NL&nbsp;
Can you show the expected result? I don't quite&nbsp;understand the requirements from your explanation
&nbsp;

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

&nbsp;

nelleke-nl · Answer

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?&nbsp;&nbsp;

wdx223_daniel · Answer

hope this can help

&nbsp;

nelleke-nl · Answer

Almost....&nbsp;= 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?&nbsp;&nbsp;&nbsp;&nbsp;And to test in the big tabel.&nbsp; I need to understand where the formule the link is to the right columnMy table has a lot of columns. How can I select the right columns? (hulpvraag + probleemstelling + reden niet in behandeling)&nbsp;