Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
82 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |