Dear All
I have a excel sheet in the following style
Project|Lead|manager ---> Header
ABC|XYZ|PQR
DEF|LMN|OPQ
I would like the macro to arrange my data in the following way
Project|ID|Role ---> Header
ABC|XYZ|Lead
ABC|PQR|manager
DEF|LMN|Lead
DEF|OPQ|manager
Your help would really be appreciated
Regards
Ujo