I would like to create another worksheet with some of the data but display it
differently.
Sheet 1 headers

date # time A, B, C, D, E item #
1 Jan 123 1011 C abc 29
2 Jan 99 1010 D def 88
3 Jan 77 900 A
3 Jan 188 1100 C abc 29
3 Jan 155 600 D

Sheet 2 headers

date A B C D E
1 Jan 123
2 Jan 99
3 Jan 77 188 155

I have formulas at the end of sheet 1 computing average for total # and
averages of A, B, C, D, E.

Auto filter will not work for this. Advance filter work with different
headers?