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