Turn 3 columns into 1

Thread view:

Thread rating:

David Stricklen - 13 May 2008 21:57 GMT

I have 3 columns that I would like to be merged in to one. For example:

b2=3 c2=4 d2=6, and so e2 = 3
e3 = 4
e4 = 6

Thanks for anyone that can help

Peo Sjoblom - 13 May 2008 22:33 GMT

Copy and paste special and select transpose

Signature

Regards,

Peo Sjoblom

>I have 3 columns that I would like to be merged in to one. For example:
>
[quoted text clipped - 3 lines]
>
> Thanks for anyone that can help

--------------------------------------------------------------------------------

>I have 3 columns that I would like to be merged in to one. For example:
>
[quoted text clipped - 3 lines]
>
> Thanks for anyone that can help

Bob I - 13 May 2008 22:35 GMT

Your example makes absolutely no sense, try again.

> I have 3 columns that I would like to be merged in to one. For example:
>
[quoted text clipped - 3 lines]
>
> Thanks for anyone that can help

Gord Dibben - 13 May 2008 23:45 GMT

Play with this entered in E2 and copied to E4

=INDEX($2:$2,ROWS($2:3))

Gord Dibben MS Excel MVP

>I have 3 columns that I would like to be merged in to one. For example:
>
[quoted text clipped - 3 lines]
>
>Thanks for anyone that can help