Hi guys -
I am trying to create a macro or query where the data from one template is automatically transposed into another template for a data import.
One template has data that is listed vertically in two columns; however, I need this to be transposed horizontally so that our system can accept it as part of a data import. I have attached a screenshot for your reference.
Can someone help me automate this process so that I can click on a macro or query to automatically transpose that data to the final horizontal template? Any insight would be very much appreciated.
Thanks in advance!