Best Way to organize cells

Hello,

I want to know what is the best way to organize a cell.
In this cell I'm entering many suppliers name and for each supplier I'm adding a second cell category in front of each supplier name I'm adding the activity of the supplier.
But many of these suppliers have more than one activity.

for ex: supplier xxx >>> activity: Pumping
Supplier yyy >>> activity: Pumping + Steel
Supplier dddd >>> activity: Steel + Welding work

Any suggestions
Thanks

It might be better to have a column for each activity, e.g. column A for Supplier's Name, column B for Pumping, column C for Steel, column D for Welding, and so on, and then you can just put Y or 1 in the appropriate column against each name.

Of course, it all depends on what you want to do with the data once you have recorded it.

Hope this helps.

Pete

But you think in case of Filtering Will this way makes my work harder or simple?

Thanks for your help

Well, if you wanted to find suppliers for Steel, for example, then you can just apply Autofilter to the Steel column (C) and select Y from the filter drop-down - that's fairly simple.

Hope this helps.

Pete

We will try this way.
But in this case filing in hard copies will be so difficult.

Thanks Again

It may be difficult to add many activity cells, this way will be hard to remember where a chosen activity is placed (is it placed in activity1 or 2 or 3...)

I have more than 50 activity
Like for ex :

Manpower+Equipmnet
Industrial tools & Equipment
Electro-industrial equipments
Steel piping material
Pipes
Tools & Consumables for Mechanical Works
Steel Works

So here we have such a supplier activity is pipes and another one activity is Steel piping material.

So putting an X under each activity >> I'll end up with a huge number cells...