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.