How to append multiple columns in one column

[Anonymous]

Hi,

I am trying to append multiple columns in one. My data looks something like below:

scorer 1	scorer 2	scorer 3	scorer 4
Di Stefano	Rial	Marquitos	Rial
Di Stefano	Gento
Di Stefano	Rial	Gento
Mateos	Di Stefano

Now, I need my data to look like below: (Scorer 1, scorer 2, scorer 3, scorer 4 appended in rows and so on)

Scorer_List

Di Stefano

Rial

Marquitos

Rial

Di Stefano

Gento

Di Stefano

Rial

Gento

Mateos

Di Stefano

Any idea about how to achieve this?

Kind Regards,

Ankit Kaushik

[vivran22]

@Anonymous 

Please find the pbix file here

Regards,

Vivek

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions help users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[Anonymous]

Thanks Vivek, It worked.

[tex628 · Accepted solution]

Highlight all columns:


Then press unpivot:


Then you can just remove the blanks! 

Br,

J

[Anonymous]

Thanks @tex628 for such a quick response. Much appreciated and it worked like a charm!