< Go Back

Excel - COLUMN Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.