Has to create dropdown

[zoharb]

Respected,
Has to create dropdown of Maximum 10 entries showing list of unique values in each columns for all columns
had used unique(it supprts in xl2021 but if possible I want some other way as some managers has xl2007 on win7)
Zohar Batterywala

Timestamp	EMPNAME	SUPERV	CLIENT	STOREID	ITEM	unit cost	Units sold	MODE
05/Jun/2015-13:08	VFGADHLN1	SHRADHLN1	DHLNANGU5	DHLN1	DatUS500gm	411	2	offline
27/Nov/2015-05:23	LONNDHLN5	ROSHDHLN2	DHLNANGU3	DHLN5	ALMUS500gm	1330	1	online
26/Feb/2016-12:05	JTVJVDKB3	HCXGVDKB3	DHLNsnso3	VDKB3	NVSP115GM	140	8	offline
26/Feb/2016-12:05	JTVJVDKB3	HCXGVDKB3	DHLNsnso3	VDKB3	CTCAS500GM	407	2	offline
26/Feb/2016-12:05	JTVJVDKB3	HCXGVDKB3	DHLNsnso3	VDKB3	DatUS2500gm	448	5	offline
26/Feb/2016-14:05	LVCDDHLN1	ROSHDHLN5	DHLNANGU1	DHLN1	DatUS1500gm	1185	1	offline
26/Feb/2016-14:05	LVCDDHLN1	ROSHDHLN5	DHLNANGU1	DHLN1	CTCAS500GM	407	2	offline
26/Feb/2016-14:55	BBYGDHLN5	DNDYDHLN2	DHLNANGU5	DHLN5	DatUS500gm	405	4	online
26/Feb/2016-14:55	BBYGDHLN5	DNDYDHLN2	DHLNANGU5	DHLN5	CTCDG500GM	155	8	offline
04/Oct/2016-16:32	KVRUDHLN4	ROSHDHLN2	STRNDNGU5	STRN2	CTCAS500GM	407	2	online
04/Oct/2016-16:32	KVRUDHLN4	ROSHDHLN2	STRNDNGU5	STRN2	DatUS1500gm	299	6	online
14/Oct/2016-13:47	ILWDDHLN2	ZYDUDHLN2	DHLNANGU3	DHLN2	ALMUS500gm	1330	1	online
14/Oct/2016-13:47	ILWDDHLN2	ZYDUDHLN2	DHLNANGU3	DHLN2	NVSP115GM	140	5	online
10/Nov/2016-16:27	HGELDHLN1	ROSHDHLN4	VDKBSUSH2	DHLN1	DatUS1500gm	1185	1	online
10/Nov/2016-16:27	HGELDHLN1	ROSHDHLN4	VDKBSUSH2	DHLN1	NRPIMN1000GM	260	2	online