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]

@Kay327 

This might be a step in the right direction.  It still needs the relevant CODE records to be merged.  More in a bit...

[phottovy]

Hi @Kay327 ,

I don't believe it is possible to merge the cells but you can make certain cells null to create a similar looking table. The attached workflow creates this view that can be exported to excel:

[hellyars · Accepted solution]

@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. 

 

 

[hellyars]

I noticed the CODE sequence changed.  There should be away to fix this using a RecordID or Tile tool.