cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Splitting the column values with comma and storing them as rows

Hi, I have some data where it comes up as below. I need to split them by comma and transpose them to row data with Client ID column getting duplicated for those multiple hardship values we have.

 

EX: i need it like Client ID     Hardship

                             5               Struggling with financial...

                             5               unsuitable for public....

                             5               limited family supp....

 

my values are dynamic and i can just do it once off. Please help.

 

 

hardship.PNG

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Microsoft
Microsoft

 Hi @Bokbob

 

In the Query Editor, highlight your column and then select "Split Column".  This will bring up a dialog box where you can specify that you'd like to split to rows.

 

 

split to rows2.png


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

Highlighted
Helper I
Helper I

Hi All,, sorry i got the answer..

 

i had to do 

 

split column values with comma values

and then unpivoted other columns

and it worked 🙂

 

View solution in original post

3 REPLIES 3
Highlighted
Microsoft
Microsoft

 Hi @Bokbob

 

In the Query Editor, highlight your column and then select "Split Column".  This will bring up a dialog box where you can specify that you'd like to split to rows.

 

 

split to rows2.png


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

Highlighted
Helper I
Helper I

Hi All,, sorry i got the answer..

 

i had to do 

 

split column values with comma values

and then unpivoted other columns

and it worked 🙂

 

View solution in original post

Highlighted

Hi Phil, Thanks so much for you help 🙂

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors