Stopping the column header repeating when you have a group by in the Basic Table tool

[tom05]

Hello, I have created an output in the basic report tool where I group one field. The problem I have is the column header is then repeated on each line or group of lines. Is there a way to prevent this happening, and just have one row of column headers at the top?

Added is how the output currently looks and the output I desire with only the top column header.

Thanks

[Amarendra]

Hi @tom05 Do you mind attaching the datasets?

[tom05]

Attached - I have had to replicate a test database as the data is confidential. 

I would be looking to group together those that have the same reference in Column 5 on the output

[Amarendra]

@tom05 I grouped the data before using the table tool (PFA). I haven't been able to find a workaround to fix the table tool grouping though