Sort based on column H, then use Data / Subtotals.... and set the subtotals to sum based on changes
in column H, and sum whichever columns you need to. Then hide the data using the - signs that
appear to the left, select all the cells, use Edit / Go to... / special / visible cells / OK, copy,
and then choose a place to paste and paste values.

HTH,
Bernie
MS Excel MVP


"General" wrote in message
...
I have a a load of data on a single sheet. I need to consolidate to the
unique values present in column H, whilst maintaining the header rows and
format of the sheet. Does anyone have some code to do this please?