Select multiple items in a cell from a list

Thank you for your response. What I’m trying to do is to fill out a column that has hundreds of rows with items from a preset list. In many of the cells I need to include more than one item from that list, separated by a comma. I tried using a validation list, but this allows me only to choose a single item for each cell, which is not what I need.

And the problem is that I’m new to excel and have never done any programming, so don’t know how to proceed.

I’m copying below the Excel sheet I did with the columns with a validation list, which is as far as I got.

I’d really appreciate any suggestion on how I should proceed.

Thank you very much,

Hopper8

Thanks for your response. There was before a difference in the upload with the validation list I did in column C.

But in light of your comment and to make it more clear, I made a new excel sheet where I wrote a couple of examples of what I need the cells to fill in.

To explain the new file I’m attaching:

What I’m trying to do is to fill out column C that will have hundreds of rows with items from a preset list (detailed in column B). In most of the cells in column C I need to include more than one item from column B in the same cell, that list, separated by a comma. Examples of what I need are in cells C2, C3 and C4. These cells I filled in manually, writing each item. What I’m trying is to find a way in which I could just tick the relevant items from the preset list.

I tried to do so using data Validation list, but this allowed me only to choose a single item for each cell, which is not what I need.

And the problem is that I’m new to excel and have never done any programming, so don’t know how to proceed.
I’d really appreciate any suggestion on how I should proceed.

Thank you very much,

Hopper8