Hi all,

I have the folowwing data:

A1 B1 C1 D1 E1
Costs 100 200 125 2002562


What I need is to copy the data oto put like this:

A1 B1
2002562 100
2002562 200
2002562 125

Is there a way to do this using a macro or a function ? I tried to use
the transpose faunction but it didn't work

Can someone help me ?

Thank you

Ricardo galveia