Need assistance formatting a table

Kay327

I need assistance formatting data in a table. My table current looks like this:

I would like to format the table to look like this:

Remove the header from column 1, 2, and 3 (only display the data). Not repeat data in column 1 (keep the first instance of the data and remove any duplicates after).

Thank you...

hellyars

@phottovy   @Kay327  I got it to work.  I was able to merge the CODE cells.   See the attached workbook.  I had to split the header row, data rows, and total row into separate table elements and then bring them back together.  How would you simplify?  This exports to Excel. 

formatTableKay327_v2.yxzp