freerskys
New Member
- Joined
- Jul 24, 2014
- Messages
- 29
- Office Version
- 2010
- Platform
- Windows
Hello Friends, I need help with a project I’m working on, please.
There are 4000 Rows, consisting of, Cell A = First Name , Cell B = Last Name.
Last Name will have Doubles, if so, all the first names that are associated with the double last names, would all go next to the first last name , all in one cell.
Example:
Tom King
Lucy King
Jane King
Result: Tom, Lucy, Jane King.
Put this on the same row next to the King (Cell).
Do this, till the end of the 4000 rows.
Using Excel 2010.
Thank you.
There are 4000 Rows, consisting of, Cell A = First Name , Cell B = Last Name.
Last Name will have Doubles, if so, all the first names that are associated with the double last names, would all go next to the first last name , all in one cell.
Example:
Tom King
Lucy King
Jane King
Result: Tom, Lucy, Jane King.
Put this on the same row next to the King (Cell).
Do this, till the end of the 4000 rows.
Using Excel 2010.
Thank you.