I’m trying to transpose data from one table to another and been wanting to create a simple structure where something like this fits:
Table 1
Client
Tariff A
Value A
Tariff B
Value B
1
AAA1
1.2
BBB1
2.5
2
AAA2
2.3
BBB2
4.3
Table 2
Client
Tariff
Value
1
RS1
1.2
1
RS2
1.5
2
RS2
2.3
3
BBB1
4.5
These are two tables with different levels of tariffs but I need to have them all in one table. For each client I can have different levels of tariffs.
In the end I would like to have something like table 3:
Table 3
Client
Tariff A
Value A
Tariff B
Value B
Tariff R1
Value R1
Tariff R2
Value R2
Tariff B1
Value B1
1
AAA1
1.2
BBB1
2.5
RS1
1.2
RS2
1.5
-
-
2
AAA2
2.3
BBB2
4.3
RS2
2.3
-
-
3
BBB1
4.5
Do you have an idea how can I accomplish to create something like it?
Thanks for your answer. Actually I'm trying a different solution because I don't want to 'close' the tariffs, every month I can get new ones and I would like them to be automatically adressed.
