How do you merge data from numerous cells into just one cell?
 

I have a list of around 4 thousand people. Each person belongs to one "Group"
which is tagged with a number.

Basically there are two columns one showing the name and one with the group
tag. What i want to do is have the group tags showing all the people who
belong to that group.

So I need to merge the data from a number of cells into one cell without
losing the data. Any ideas?

Thanks for your help.

Try:

=B3&""&C3&""&D3

I added the "" so a space is included in between cells. You can remove it
if you don't need a space.



"Senior" wrote:


I have a list of around 4 thousand people. Each person belongs to one "Group"
which is tagged with a number.

Basically there are two columns one showing the name and one with the group
tag. What i want to do is have the group tags showing all the people who
belong to that group.

So I need to merge the data from a number of cells into one cell without
losing the data. Any ideas?

Thanks for your help.

Make sure that there is a space between the quotation marks. (I didn't in my
origninal post, oops.)

=B3&" "&C3&" "&D3


"StinkeyPete" wrote:

Try:

=B3&""&C3&""&D3

I added the "" so a space is included in between cells. You can remove it
if you don't need a space.



"Senior" wrote:


I have a list of around 4 thousand people. Each person belongs to one "Group"
which is tagged with a number.

Basically there are two columns one showing the name and one with the group
tag. What i want to do is have the group tags showing all the people who
belong to that group.

So I need to merge the data from a number of cells into one cell without
losing the data. Any ideas?

Thanks for your help.