Many thanks for your help
I will try the query above.
Indeed the total records in my consolidated table is 255K and growing.
I usually use excel for everything but this time I need a dynamic sheet/table per customer that updates every time my consolidated table grows.
I have ordered the table...