Values in Columns to convert in rows

C

Carpe Diem

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
 
C

Carpe Diem

Hi Gary,

It worked justv like I need but I have about 1500 lines with values to
copy how can I do it ?

Thank You for your help.

Ricardo
Gary''s Student escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy values in rows to columns 1
Tranfer data from Excel to word (Docx) via VBA in Excel 5
Rows with cells of varying number of lines 5
Worksheet program to convert parent/children data to string(s) 1
Find and transpose adjacent values 1
Macro to concatenate columns 1
Flipping Data 4
*Assistance with formula* 3

Top