Hi, I can’t figure out how to perform the following conversion. (Tried Pivot, Unpivot, Group, but nothing seems to work…)
I need to group by seller and buyer and set columns as rows, as follows:
If this example is too complex, simplified version would just not have 2nd item. So, if I can solve this for one item, I think I can do the rest with derived tables and then union them back.
Examples excel attached. All pointers and suggestions are appreciated. Book1.xlsx (11.3 KB)