Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
SonaSinghA
Helper III
Helper III

Data Pivot help

Helo experts,
Need to pivot data like below
Please help

NoNameType
100, 101, 102AppleFruit
200, 201, 202OnionVeg
   

 

NoNameType
100AppleFruit
101AppleFruit
102AppleFruit
200OnionVeg
201OnionVeg
202OnionVeg
1 ACCEPTED SOLUTION
Daniel29195
Super User
Super User

Hello @SonaSinghA 

 

do the following : 

step1 :  select the column to expand to rows and click on spit columns -->  by delimiter,

Daniel29195_0-1706699888186.png

 

step 2 : 

Daniel29195_1-1706699916435.png

 

hit enter. 

Daniel29195_2-1706699936584.png

 

 

 

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! 🤠

 

View solution in original post

3 REPLIES 3
Daniel29195
Super User
Super User

Hello @SonaSinghA 

 

do the following : 

step1 :  select the column to expand to rows and click on spit columns -->  by delimiter,

Daniel29195_0-1706699888186.png

 

step 2 : 

Daniel29195_1-1706699916435.png

 

hit enter. 

Daniel29195_2-1706699936584.png

 

 

 

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! 🤠

 

Missed advanced options. Thanks
zenisekd
Super User
Super User

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. 

zenisekd_1-1706699864287.png

Kudos and mark as solution appreciated 🙂

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.