How to arrange data for creating a Dashboard

[Sekayi_Liburd]

do you need to do something like this?

Changing horizontal data to vertical with =TRANSPOSE

there’s also this thread:

Transpose data from a column in one table to another table in a row

I want to automatically copy numeric values from a column in GlideApp-Table 1 to a row in GlideApp-Table 2. I will do this with multiple columns in table 1 to pair them with their rows in table 2 that have the same name. Context: In Table 1, the column name is Savings and each row in this column represents the numeric value in a given month In Table 2 the row represents Savings and each column will represent the months I am basically transposing data cross different tables from a single col…