Export field data as a header for another field
I am tracking letters sent.
In the first table I have a serial ID and various general letter feed data.
In another table I have a field titled letter category. I have about 5 different types of letters. The next field is a date the letter was sent and Letter specific feed data like amounts, date and tracking #.
When I export. I get the ID, Letter Type and Date on the same row in Excel. With the headers being the field names.
I would like the ID and the date on the same row. Then have the Letter Type as the header for the date column.
Example: I would like cell A1-"Serial" B1-"1st Letter" A2-"the serial number" and B2-"Letter Date"
and if my export has more than one Letter types it will continue to the "C" column with the date of that letter under the header.