Nancy

Do not ignore Lars-Ake's formula solution which works as you want.

Just make sure you change his semi-colons to commas.


Gord Dibben MS Excel MVP

On Mon, 14 Apr 2008 11:54:03 -0700, Nancy
wrote:

how would i seperate those into seperate cells?

"Pete_UK" wrote:

I'm not really sure what you want, but try this in D1:

=$A1 & " " & $B1 & " " & $C1

Copy this into E1:G1, but change the row number each time, i.e.:

E1: =$A2 & " " & $B2 & " " & $C2
F1: =$A3 & " " & $B3 & " " & $C3
G1: =$A4 & " " & $B4 & " " & $C4

Hope this helps.

Pete

On Apr 14, 7:08 pm, Nancy wrote:
PLEASE HELP!!! I'm GOING CRAZY!
i have 3 seperate columns
EX:
NAME CITY STATE
Nancy Sacramento CA
Danny Miami FL
Lucy St. Paul MN
Shorty Hickory NC

i want to transpose all 3 columns into 1 row (seprate cells)
EX:
Nancy Sacramento CA Danny Miami FL Lucy St. Paul MN Shorty Hickory NC
Is this even possible? i know you can do 1 column but what about 3?
IS there a formula i can use to pull the information?

EX:
If i transpose just the 1st column and insert two blank columns between the
names
Nancy Danny Lucy
Shorty
is there a function i can use to pull the information above and insert it in
the blank cells?

EX:
i tried the IF(Nancy=a1:a5,b1:b5,Error) and it worked, but only with Nancy

i guess what i'm trying to say is, find the name, pull city and state of
that person and paste it in the blank cells....

Please help, i'm so confused i don't even know what i'm talking about anymore.