How to select sorted data listed under an unsorted grouping?

G

Guest

The objectivon is to list card numbers (i.e. 0006, 0011, 1297, 2305, etc.) on
a sheet (Sheet 2) in the same row as the package designation (i.e. BC01X,
BC02A, BC03B, etc.) for that group. The data comes from a sheet (Sheet 1)
where the card numbers column is sorted, but the package designation is not.

The number of cards varies from package to package. The listing of card
numbers on the packages sheet (2) must be in consecutive cells within the row
with no blanks in between.

Example:

BC01X 0002 0009 0022 0096 0588 1122
BC02A 0006 0016 0038 1445
BC03B 1233 1235 5996 6093 6095 7022 7145 8432
 
M

mcg

add one more (C) column with formula "
count.if($A$2:A2;A2)
i assumed that col A contains package designation & B 0002 0009 etc
then create pivot table
& format its contents as 0000
mcg
 
Top