I have 250 people, each person has their own row. Each person has the option
of selecting 2 out of 11 options. The options are arranged horizontal going
across. E.g. Person 1 can pick option 1 and 3, person 2 can pick 4 and 11.
Person 3 can pick 5 and 9, etc.
I wanted to collapse the data, so I can get everything summarized into 3
columns, one for the person, one for first option picked and next column over
for second option picked.

Thanks again.
--
Tabit


"Rick Rothstein (MVP - VB)" wrote:

I'm still having trouble visualizing your layout. Are all 2750 cells devoted
to options filled in with "something" and you are somehow designating the
two options per row to be selected (maybe background color change)? Or do
you have 11 columns devoted to options (perhaps with an option name in the
header) where you select (maybe by placing an "X" in the two columns) and
you want to pick up the selected cell's header name and concatenate those?
We are still talking about concatenating, right?

Rick


"Tabit" wrote in message
...
Thanks for your quick response, my fault, I believe I should rephrase the
question as it was unclear.
I have 250 entries in one sheet, each entry has 11 options going across,
each entry can pick at most 2 options out of the 11.
I would like to find a way to pick up and put on another sheet, only the 2
options selected for each entry.
--
Tabit


"Rick Rothstein (MVP - VB)" wrote:

Help needed to concatenate 11 cells on same sheet, all of them in
the same row into two. Of the 11 cells, only max of 2 in each row
are filled out, others are left blank. How can I concatenate these
11 cells into 2 for each row?

If I understand your question correctly, just link the with ampersands.
Assuming we are talking about the first 11 columns...

=A1&A2&A3&A4&A5&A6&A7&A8&A9&A10&A11

Rick