one cell value to multiple rows

[Anonymous]

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.

[Greg_Deckler · Accepted solution]

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