I want to set a summary page of data collected per part numbers. I want to
add alike cells that have the same part number. The user chooses a part
number from a list. The user will choose a part number for each column to
collect data; some part numbers may be repeated (only one part number per
column). I want to create a summary page that will calulate the data based
on part number. My only problem is that I need to set the headers correctly
without repeated the same part number twice. Below is a very small example
of my problem.

A B C D E F

1 Part #3 Part #1 Part #4 Part #4 Part #2 Part #3

The desired results would be:

G H I J
1 Part #1 Part #2 Part #3 Part #4

The part numbers are all in one row (C3 thru DR3), No headers. The data
will not be in any order and will change periodically. Unfortunately, The
part numbers are both text and numerical.