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.
Go to Solution.
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.
Proud to be a Datanaut!
View solution in original post
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 🙂
Hi Phil, Thanks so much for you help 🙂
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.