Hi all,

We send test reports to clients in PDF format. The client has requested to receive the data as CSV. Our system is set up with the main form called "Groups", and sitting inside that is a subform called "Samples". The samples subform contains a reference number and test age etc.

The client would like the ages for 7-day, 14-day and 28-day to show as shown below:

See the final info below this image

Zoho lists everything in the report vertically. Is it possible to list the data as all 7-day, 14-day and 28-day all in their own column? Would I have to resort to a Pivot table, or does anyone know a way around this?

Below is how Zoho lays it out.

Any help given is greatly appreciated.

Many thanks

Nick