Copy columns values into separate columns

[Mike_can]

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

[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.

[luvthavodka]

Follow the text to columns function Mike... this should help.

"Mike_can" wrote:

> 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

[Mike_can]

mm no this won't work ... beacuse the data is already in several columns.

"luvthavodka" wrote:

> Follow the text to columns function Mike... this should help.
>
> "Mike_can" wrote:
>
> > 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

[Mike_can]

? but i have 150 columns!!!!!!

"bgeier" wrote:

>
> 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.
>
>
> --
> bgeier
> ------------------------------------------------------------------------
> bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
> View this thread: http://www.excelforum.com/showthread...hreadid=546050
>
>

[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?

[Mike_can]

The columns have fixed data (numbers only)

"bgeier" wrote:

>
> 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?
>
>
> --
> bgeier
> ------------------------------------------------------------------------
> bgeier's Profile: http://www.excelforum.com/member.php...o&userid=12822
> View this thread: http://www.excelforum.com/showthread...hreadid=546050
>
>

[Dominic LeVasseur]

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.


"Mike_can" wrote:

> 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