Forum Discussion
Data Pivot help
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 10...
Hello Anonymous
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 🙂