I need to make maps showing one record at a time, but all the attributes in the table. Is there some way that I could insert the attribute table (Table Frame) and then pivot it like this:

Instead of like than this:

I know I could do it in Excel and then copy and paste it into the layout ... but that is too time consuming.
Alternatively is there a way to create dynamic text that looks at the attributes in the table?