Formatting Workflow Template

Thanks in advance for any help,
I have been working on this problem for a while and cannot seem to find a solution. I have an email template workflow that sends a report from my “Query_Data” table. In my template, I use this formula <<START:ORDERBY(SELECT(Query_Data[_ComputedKey],AND([Year]=[_THISROW].[Year],[Month]=[_THISROW].[Month],[Day]=[_THISROW].[Day],[company]=[_THISROW].[Company],[farm]=[_THISROW].[Farm],[crop]=[_THISROW].[Crop],[Field Type]=[_THISROW].[Field Type])),[crop],true)> I would like to switch the rows and columns, the same way you would use TRANSPOSE in sheets. In the format I have now, I have to use multiple tables to fit all the columns and it causes the PDF to be multiple pages and difficult to scroll.This is how I have it set up now:

I need it to look more like this:
I am also open to any other suggestions on how to organize this data to make it readable and condensed. I hope I explained this well enough…

0 4 920
4 REPLIES 4
Top Labels in this Space