macro to copy paste in excel Closed

Question

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

Trowa · Answer

Hi Ujo,

Let's say your data has the range A1:C3.

Now create a new sheet and type in the following:

=Sheet1!A1--------ID--------Role
=Sheet1!A2	=Sheet1!B2	=Sheet1!B1
=Sheet1!A2	=Sheet1!C2	=Sheet1!C1
=Sheet1!A3	=Sheet1!B3	=Sheet1!B1
=Sheet1!A3	=Sheet1!C3	=Sheet1!C1

Hope this helps you.
Best regards,
Trowa

Macro to copy paste in excel

1 response

Similar discussions

Subscribe To Our Newsletter!