This is probably a very basic question for this forum:

How do I combine two columns with multiple keywords in each column?
Example:
A B
Toyota Car
Prius Lease

Toyota Car
Toyota Lease
Prius Car
Prius Lease

Thanks