Hi Don

As i said earlier i can pull the unique names of the sales person
from the data and put it on column A starting from row 2.
But what about items ? How can i put the unique item names
on row 1 starting from colum B ? Surely i wouldn't know the number of
items, would i ?
Like:
item1, item2, item3
John
George
Adam

Regards