Get the column Header where value matches in multible columns

Hi,

Looking for a help.

I have first column with user id's and the rest of the columns contain their roles. There are tick marks if they belong to one or more roles.

Explained in detail below

Column A heading is User Id
Column B heading is Support User
Column C is Administrator
Column D is Business
Column E is Process team and so on

A user can belong to one or more roles.

I want the data in separate rows if the user has multiple role

User1 Support User
User1 Administrator
User2 Support User
User3 Business
User4 business
User5 Process Team
User5 Support User

like this.. Please help how to achieve this in excel. I dont know VBA scripting

Hi,

Attaching the sample excel where first sheet contain Input and the second sheet contain the out put I need.

Thanks,
Padmini

HI,

For some reason not able to attach the file. Below is the i/p nd o/p

Input:

Id A B C D F
1 Yes Yes
2 Yes Yes
3 Yes
4 Yes
5 Yes
6 Yes
7 Yes Yes

Output:

Id Role
1 A
1 C
2 B
2 D
3 A
4 A
5 B
6 B
7 A
7 C


Thanks,
Padmini