Splitting the column values with comma and storing them as rows

[Bokbob]

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.

[Phil_Seamark · Accepted solution]

 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.

[Bokbob · Accepted solution]

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 🙂

[Phil_Seamark · Accepted solution]

 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.

[Bokbob]

Hi Phil, Thanks so much for you help 🙂