Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to Solution.
Highlight all columns:
Then press unpivot:
Then you can just remove the blanks!
Br,
J
@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!
Thanks Vivek, It worked.
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!
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
70 | |
38 | |
28 | |
26 |
User | Count |
---|---|
97 | |
88 | |
59 | |
43 | |
40 |