Copy columns values into separate columns

G

Guest

Hi

I'd like to copy the values from columns that are together (a,b, c, d...) in
another spreadsheet on separate columns (a, d, g, j) is there a easy way to
do it?

Thanks a lot

Mike
 
B

bgeier

The only way to do it is to select the first column, copy it, then paste
it to the destination, then repeat for each subsequent column.
 
B

bgeier

You could set up a macro to do it for you.
Do you know the source and destinations for each?
Do they change?
Will this be recurring, or one time only?
 
G

Guest

Mike,

I don't know about copying but you could do this with a formula. I'm not
sure if this is the most efficient formula\method, but it will work.

Example:

Sheet1 has the data you want to put in another sheet. The data is in columns
A thru whatever.

Sheet2 is the sheet you want the data in.

In sheet two, somewhere out of the way (off to the right, or way down),
create a lookup table like the following:

col1 col2
1 1
4 -2
7 -4
10 -6

etc, all the way down to suit your needs. You can fill down to make this
very fast after you have done the first couple of lines (in the second
column, make sure you don't select the "1" entry when you fill).

You could create this table in another sheet also and give it a name if you
like.

Then in sheet2, in cell d2 enter the following formula:

=OFFSET(Sheet1!D2,,VLOOKUP(COLUMN(),"Lookup Range",2,FALSE))

Where you substitue your range (be sure to use absolute references) or range
name for "Lookup Range".

Then copy this formula to each of the appropriate columns (d,g,j,etc.)

Then copy the formulas down as far as you need.

There might be mathematical equation you could stick in there instead of
using the lookup range, but I'm tight on time and my math mind is gone by
this time.

Hope that helps.
 

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

Top