Hello all,
I have created a transposed HTML table that looks like the following:
My problem is populating the excel table in worksheet , "testing.xlsx", that I created with this data. The dates may change depending on the source data so the number of the date columns, 2024-07, 2024-08, etc. is not fixed. They change over time
I tried to use "Add Rows into a table" but I am stuck here. Only one row of the "Portfolio" names is populated without "Count". The table should look exactly like the first image posted earlier