Hello All…
I have an Excel sheet as shown below…
Employee ID | IT-Department | Finance-Department | HR-Department | Accounts-Department |
---|---|---|---|---|
E-0001 | Finance | |||
E-0002 | IT | |||
E-0003 | Accounts | |||
E-0004 | HR |
I want to get the above Multiple columns into a Single column as shown below…
Employee ID | Department |
---|---|
E-0001 | Finance |
E-0002 | IT |
E-0003 | Accounts |
E-0004 | HR |
Can any one please help me on this… | |
Thanks in Advance |
Regards,
Pravin.