Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |