Afternoon, very new to excel so apologies if this is simple.

I have a large amount of names in a number of columns. Is there any way I can organise them to show which columns they appear in and which one they don't?

E.g. to see whether customers have been traded with in my business in particular months.

Cheers

Chris