Forum Discussion
one cell value to multiple rows
I have data like below
App id , appname, servers(seperated with comma in single cell)
App1, application1, ser1,ser2, ser3
app2, application2, ser4,ser5
and I need conver rlike below
App1, application1,ser1
app1,application1,ser2
app1,application1,ser3
app2,application2,ser4
app2,application2,ser5
Can you please help on with power query or any other options.
Anonymous Select your last 3 columns, right click the header row of one of the columns and choose Unpivot columns. Or the reverse, select the first 2 columns, right click and Unpivot other columns.
1 Reply
Anonymous Select your last 3 columns, right click the header row of one of the columns and choose Unpivot columns. Or the reverse, select the first 2 columns, right click and Unpivot other columns.