I'm sorry I got mixed up.
Sometimes something that for us is not necessarily obvious to others.
The test0 table is the initial table at the input.
To save disk space and speed of calculations, I have made transpositions, but not classical ones, only every 7 observations.
Table test1 has changed as follows: The date column has changed to date_7 but only the last observation in a given series, i.e. obs 7 and 14.
The column var1 row 1 to 7 changed to var1_1, var1_2, var1_3, var1_4, var1_5, var1_6, var1_7 row 1, and the column var2 row 8 to 14 changed to var2_1, var2_2, var2_3, var2_4, var2_5, var2_6, var2_7 row 2 .
My problem is that after making calculations from the test1 table, I have to go back to the form from the test0 table.
... View more