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