Mail Merge with Fields extracted from ROWS instead of COLUMNS or transpose of typical mail merge

[djrexy]

EXCEL-2JPG.JPG - Google Drive

Typically a mail merge extracts data from an Excel table using the information in along a certain row as "recipients". Meaning along the same row I can input an unlimited number of COLUMNS from where I can extract the Fields. I did it successfully however I'd like to "TRANSPOSE" the Rows with Columns when it comes to Mail Merge.


I would like to be able to perform a mail merge with the FIELDS extracted from Excel ROWS instead of the COLUMNS. So basically, TRANSPOSE the FIELDS with the COLUMNS and get just one individual document with multiple fields along Column B from the image above.

1) Is this possible?
2) If yes, how can I do it?



Thank you,