Forum Discussion
Pivot a row for two columns
Hello all,
Can someone plese help me with the code how to get from Table 1 to Table 2 please? Pivot fucntion is needed but i cant figure out exact code. Thank you in advance.
Table 1:
| product | Country | Color | Value |
| fruit | UK | red | b1 |
| fruit | USA | blue | C3 |
| tree | UK | green | Z5 |
| tree | USA | yellow | K9 |
Table 2:
| product | UK | USA | UK | USA |
| fruit | red | b1 | blue | C3 |
| tree | green | Z5 | yellow | K9 |
- Can you explain the Logic behind this, it doesn't make any sense
