Hi,

Pre format your data in a table.

Use the table as the data source for a tablix report.

Eg

--4 Col table

Group1 Col1

Group1 Col2

Group1 Col3

Group1 Col4

Group1 Col5

Group1 Col6

Group2 Col1

Group2 Col2

Group1 Col1 Col2 Col3

Col4 Col5 Col6

Group2 Col1 Col2

Hide duplicates in the group and sub total for each group. Possibly even put the totals in your table.

Cheers

😎