Generate a list of tasks from dropdown options and yes/no answers

OK - first bit of advice (you would be unwise to try to ignore this!) - get rid of the cells containing multiple values. Instead, create a database with ONE set of details per record.

For example:

AliGW on MS365 Insider (Windows) 64 bit

	H	I	J	K	L	M
1	Continent	Country	Car Color	Car Price	Contact	Tel
2	The US	Ohio	Green	10000	Cleveland	1123456
3	The US	Nebraska	Blue	9000	Nebraska city	11234765
4	The US	Nebraska	Green	9000	Nebraska city	11234765
5	The US	Massachusetts	Green	11000	Boston	5432665
6	The US	Massachusetts	Red	11000	Boston	5432665

Sheet: Sheet1

Once you have done this, attach the workbook again and we can take it from there.

Databases should always be in a normalised flat format like this - it makes everything else MUCH asier.