Question description:
This user has given permission to use the problem statement for this
blog.
Hi, I have a list of names in 1 column, with title, company, etc in a row and each person has multiple emails. Each different email is in a different column. I want to copy each row and align each different email so the email is in the same column with name, title etc repeating.
Solved by F. D. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
09/04/2018 - 01:29
Hello, how can i help you?
User
09/04/2018 - 01:29
Hi
User
09/04/2018 - 01:29
Do you see what I've pasted?
Excelchat Expert
09/04/2018 - 01:29
Yup
User
09/04/2018 - 01:30
I want the email for each person in 1 column. See sheet2 for example
User
09/04/2018 - 01:30
This is only an example of a list of over 100 name
User
09/04/2018 - 01:30
each person is different, whether they have the same name or company
Excelchat Expert
09/04/2018 - 01:30
Ohkk
Excelchat Expert
09/04/2018 - 01:30
Lets try
Excelchat Expert
09/04/2018 - 01:30
Thats a tough one mate :)
User
09/04/2018 - 01:30
I know!!!!
Excelchat Expert
09/04/2018 - 01:31
Lets try though :)
User
09/04/2018 - 01:31
THANK YOU!!!!
Excelchat Expert
09/04/2018 - 01:31
Please don't screw my rating though :D
User
09/04/2018 - 01:32
Everyone needs a challenge ;)
Excelchat Expert
09/04/2018 - 01:32
Haha
Excelchat Expert
09/04/2018 - 01:33
Do you know macros?
User
09/04/2018 - 01:33
No
User
09/04/2018 - 01:33
was hoping to use formulas
Excelchat Expert
09/04/2018 - 01:33
Lets try
Excelchat Expert
09/04/2018 - 01:34
How many max email id do you have?
User
09/04/2018 - 01:34
There are 7 different emails for Max
Excelchat Expert
09/04/2018 - 01:34
or
User
09/04/2018 - 01:45
any luck?
Excelchat Expert
09/04/2018 - 01:45
Yes
Excelchat Expert
09/04/2018 - 01:45
You will need to do one thing though
Excelchat Expert
09/04/2018 - 01:45
Delete the empty rows
Excelchat Expert
09/04/2018 - 01:45
That will be fine with you?
User
09/04/2018 - 01:46
What empty rows?
Excelchat Expert
09/04/2018 - 01:46
Ill tell you what I am thinking
Excelchat Expert
09/04/2018 - 01:46
Wait, let me complete
User
09/04/2018 - 01:46
sure thing!
Excelchat Expert
09/04/2018 - 01:58
Ill have to use indirect function too
User
09/04/2018 - 01:59
Okay - I've never used that before
Excelchat Expert
09/04/2018 - 01:59
OK
User
09/04/2018 - 02:18
Do you know a formula that would allow you to lookup a value within a range and then give you a row value that the lookup value was found on, without knowing the row number but the column number? Kinda a reverse vlookup
Excelchat Expert
09/04/2018 - 02:18
yes
Excelchat Expert
09/04/2018 - 02:18
no
User
09/04/2018 - 02:19
haha which is it?
Excelchat Expert
09/04/2018 - 02:19
no?
Excelchat Expert
09/04/2018 - 02:20
im sorry :/
User
09/04/2018 - 02:20
darn was hoping there was such a thing
User
09/04/2018 - 02:27
how's it going?
User
09/04/2018 - 02:27
no luck?
User
09/04/2018 - 02:28
Thanks for trying!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
