I have a file with 10,000 plus rows of date that I need to prepare a running
summary.

Column A = site location
Column B = shelf name
Column C = slot number
Column D = status of slot ~ spare or used

Every shelf has 40 slots so column A & B repeat themselves 40 consecutive
times to show a complete inventory for the shelf.

In a separate tab I need to summarize the spare/used slots by site by shelf
name. Ideally I would like to show slots 1 - 40 in row 1 and site/shelf name
in column A. So if location USA , shelf 1 slot 1 was used cell B2 would
output "used".

Any formula suggestions would be much appreciated.

Thanks.