straight table

[marikabi]

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

[sunny_talwar]

Oh okay, now it makes sense... can you try doing this in the script?