Create a 'New List' based on specific criteria

[Steverino]

Greetings Excel Guru's,

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]Clients
[/TD]
[TD="align: center"]C
[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]R
[/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]Car
[/TD]
[TD="align: center"]Bus[/TD]
[TD="align: center"]Rail
[/TD]
[TD="align: center"]Air
[/TD]
[/TR]
[TR]
[TD]John Public[/TD]
[TD="align: center"]X
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD]John Public[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Jane Doe[/TD]
[TD="align: center"]X
[/TD]
[TD="align: center"][/TD]
[TD="align: center"]X
[/TD]
[TD="align: center"][/TD]
[TD]Jane Doe[/TD]
[TD][/TD]
[TD]Jane Doe[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mary Smith[/TD]
[TD="align: center"][/TD]
[TD="align: center"]X
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD][/TD]
[TD]Mary Smith[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]John Doe[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]X
[/TD]
[TD="align: center"]X
[/TD]
[TD][/TD]
[TD][/TD]
[TD]John Doe
[/TD]
[TD]John Doe[/TD]
[/TR]
</tbody>[/TABLE]

Clients list is the master list of all names.
From that list, I need to create separate lists based on the criteria of which each client is applicable; I.e. If "C" then client appears Only in the "Car" column, likewise if "R" is checked... the client name will only appear in the "Rail" column.
I am only able to generate a list - based on 'Data Validation' at this time, which which I have to pick and choose each name.
= Is There a Way to generate or populate a new list based on the criteria of the columns (C,B,R, and A).

[Each of the new lists will be used in multiple other worksheets]

Thank you.
I have learned more about Excel from reading your answers, than I could ever imagined.

 

[Warship]

Are we populating a grid as shown?
Or creating new lists on seperate sheets? (VBA ok?)
Or both?

For the grid:
If the header "Clients" is in A1 then
in F2 put: =IF(B2="","",$A2) then
fill across to I2 then
fill down as needed.

 

[Steverino]

Thank you Warship.
I just had to make a small addition so I didn't get a 'true', 'false' response, but it worked fine.