Need to convert cell values to column headings

Hi All,

This is a peculiar requirement that i have which i will try to explain.

I have a table in the format

User Application 1 Application 2 Application 3 ... Application N

ABC aaa bbb ccc ddd
XYZ bbb yyy
LMN ccc ddd


I want to convert it into :



User Application

ABC aaa
ABC bbb
ABC ccc
ABC ddd
XYZ bbb
XYZ yyy
LMN ccc
LMN ddd

Can anyone suggest a way this can be done in exce.

Try this

Please Login or Register  to view this content.

This allows for any amount of rows but only up to 3 applications
Change the NumofCols to the highest value of "n" where n is the "Application N"