**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.*