Sorting data

[sidd.iths]

hi,

i have data in the below fashion:

A B C
a,b,c,d 1,2,3,4 q,w,e,r

what i need to do is to convert the above into :

A B C
a 1 q
b 2 w
c 3 e
d 4 r

thanks in advance.

[Arkadi]

sidd.iths,

this is not a lot of information, can you share a workbook to illustrate what the data looks like? maybe a sheet that shows current data, and another with expected results?

[sidd.iths]

hi Arkadi,

have attached a file, hope this helps.

thanks

[Arkadi]

sidd,

I have tried to make the macro easy to edit in case your example does not use the same columns/rows as original, let me know if you have problems:

Please Login or Register  to view this content.

[sidd.iths]

hi Arkadi,

Thanks that works for the first row, could you edit the code to get results for multiple rows of data in the same format.

Thanks

[GeneralDisarray]

Please Login or Register  to view this content.

See attached: