You have not said what sort of drop down list you have but I assume that the
results of the selections are displayed in separate cells. If my assumption
is correct, assuming that the 3 separate results are in cells A1, B1 and C1
then you can concatenate the results into another cell.

=A1&", "&B1&", "&C1

The characters between the double quotes can be any characters you like to
use for the separation. In the above I have used a comma and a space.

Regards,

OssieMac


"Smatass" wrote:

I have 3 columns for 'complaint A', '..B', '..C'. Each of the cells in
those columns has the same drop-down list that contains 5 items. What I want
to do is have the item from the drop down list moved/placed automatically
into a new cell, but I want the other two drop-down lists to have their
selections moved/placed into the same cell as the first drop-down list
without overwriting the first entry. The 3 entries in the single cell would
be comma separated ideally. Does that make sense and is it possible? Any
help is greatly appreciated. Thank you.