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