N
Nancy
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.
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.