cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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

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

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

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

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors