Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Helo experts,
Need to pivot data like below
Please help
No | Name | Type |
100, 101, 102 | Apple | Fruit |
200, 201, 202 | Onion | Veg |
No | Name | Type |
100 | Apple | Fruit |
101 | Apple | Fruit |
102 | Apple | Fruit |
200 | Onion | Veg |
201 | Onion | Veg |
202 | Onion | Veg |
Solved! Go to Solution.
Hello @SonaSinghA
do the following :
step1 : select the column to expand to rows and click on spit columns --> by delimiter,
step 2 :
hit enter.
f my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution !✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
Hello @SonaSinghA
do the following :
step1 : select the column to expand to rows and click on spit columns --> by delimiter,
step 2 :
hit enter.
f my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution !✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
Hi, judging by your data, you should first split the first column by the ", " in order to create separate columns with numbers. Next you can play with pivot/unpivot columns/other columns.
Kudos and mark as solution appreciated 🙂
User | Count |
---|---|
97 | |
88 | |
76 | |
70 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |