**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need to know How I can get the first name column and last name column and a third column for a speaker they chose to be in the same book? We are using constant contact and the attendance is put for us as 1 individual or 2 attending that session.

Solved by D. B. in 18 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
12/02/2018 - 03:09

Hello.

User
12/02/2018 - 03:09

hello

Excelchat Expert
12/02/2018 - 03:09

Welcome to Excel Chat.

Excelchat Expert
12/02/2018 - 03:09

How may I help you?

User
12/02/2018 - 03:09

yes please

Excelchat Expert
12/02/2018 - 03:10

Please let me know what you want to get done.

Excelchat Expert
12/02/2018 - 03:10

It would be great if we work with some sample data. Please use the sheet to show some data here.

User
12/02/2018 - 03:11

we are using constant contact in preparation for a conference and I am trying to match the first and last name of the people with the speaker session that they are attending

Excelchat Expert
12/02/2018 - 03:11

ok

Excelchat Expert
12/02/2018 - 03:12

Ok. So what 1 means in column C, D and E

User
12/02/2018 - 03:13

the 1 and 2 signify if it it one individual attending or a couple

Excelchat Expert
12/02/2018 - 03:13

Ok. I got it.

User
12/02/2018 - 03:13

for example julie nd john are a couple wanting to attend the same session

User
12/02/2018 - 03:14

I am trying to get a formula that help me attch a name to the speaker session, so when I print the session... I get all the people attending under the hreading

Excelchat Expert
12/02/2018 - 03:14

And Julie has no relation with the John Keeper in row 4

User
12/02/2018 - 03:15

yes they are a couple... but each is placed i=on a line because in the other 2 sessions as you see each is attending a different session

User
12/02/2018 - 03:15

is it possible ?????

Excelchat Expert
12/02/2018 - 03:15

Ok. But then it would be difficult to know how they are related.

User
12/02/2018 - 03:16

we know it through paypal.....

Excelchat Expert
12/02/2018 - 03:16

Then you have to enter that information first.

Excelchat Expert
12/02/2018 - 03:16

in a separate column.

User
12/02/2018 - 03:16

ok

Excelchat Expert
12/02/2018 - 03:16

But then it would become more of a VBA macro task.

Excelchat Expert
12/02/2018 - 03:17

Anyway give me few moments to think if this can be done through some formula.

User
12/02/2018 - 03:17

excuse my ignorance..

User
12/02/2018 - 03:17

what is that

User
12/02/2018 - 03:17

thank you

Excelchat Expert
12/02/2018 - 03:17

VBA macros are pieces of code supported by Excel to automate tasks.

User
12/02/2018 - 03:18

oh ok

User
12/02/2018 - 03:18

thank you

Excelchat Expert
12/02/2018 - 03:24

Sorry to keep you waiting.

Excelchat Expert
12/02/2018 - 03:24

I am attaching a sample worksheet, which uses Pivot to filter out the attendance lists.

User
12/02/2018 - 03:24

its ok... thank you for trying to help me!

User
12/02/2018 - 03:25

thank you

Excelchat Expert
12/02/2018 - 03:25

[Uploaded an Excel file]

Excelchat Expert
12/02/2018 - 03:25

Please see this sheet. But for your use, this doesn't consider the couple yet and you will have to modify the Pivots depending on your data.

User
12/02/2018 - 03:26

perfect I appreciate your help!

User
12/02/2018 - 03:26

Thank you

Excelchat Expert
12/02/2018 - 03:26

This way you can filter out the attendance lists for different speakers.

Excelchat Expert
12/02/2018 - 03:26

I am glad that I could help you.

User
12/02/2018 - 03:26

bless you heart I really appreciate your help

Excelchat Expert
12/02/2018 - 03:26

Thanks for your kind words.

Excelchat Expert
12/02/2018 - 03:26

Hope to see you here again soon.

User
12/02/2018 - 03:27

most definitely!!!!

Excelchat Expert
12/02/2018 - 03:27

You can close this session now. Bye! :)

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