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
Bookmarks