Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello,
I'm working on a straight table and I really can't find a solution for my issue.
My data source looks like this:
Shop_A
Shop_Z
Quantity_shipped
eg
Shop_A | Shop_B | Quantity_shipped |
Milan | Rome | 10 |
Milan | Paris | 50 |
Milan | Prague | 8 |
Milan | Bratislava | 20 |
Rome | Milan | 5 |
Paris | Milan | 15 |
Prague | Milan | 10 |
Bratislava | Milan | 18 |
What I would like to achieve is a table where for each shop combination A-B I see the quantity IN and the quantity OUT:
Shop_A | Shop_B | Quantity_shipped_IN | Quantity_shipped_OUT |
Milan | Rome | 10 | 5 |
Milan | Paris | 50 | 15 |
Milan | Prague | 8 | 10 |
Milan | Bratislava | 20 | 18 |
Many thanks in advance
Oh okay, now it makes sense... can you try doing this in the script?