Forum Discussion
How to append multiple columns in one column
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
Highlight all columns:
Then press unpivot:
Then you can just remove the blanks!
Br,J
4 Replies
Highlight all columns:
Then press unpivot:
Then you can just remove the blanks!
Br,J
Thanks tex628 for such a quick response. Much appreciated and it worked like a charm!
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!
