Hi JaB,

I think you will have to rearrange your data into three columns. Column
1 = dates, Column 2 = Hats and Column 3 = Coats.

The best way to do it would probably be to use autofilter to hide the
blank cells in the dates column, then copy and paste the dates to
another part of the sheet or the same place on a different sheet. Then
use the auto filter to hide the cells with "Coats", then copy and paste
the Hat values in the column next to the previously pasted date values.
Then the auto filter to hide the "Hat" cells, then copy and paste the
Coat values.

I've had to guess your current data structure, it looks prety messy on
my screen.

Ken Johnson