Order line SKU combinations

[Anonymous]

Can anyone assist with the following issue I've been stuck on for days, I have a table that has two columns: "Item Number (SKU)" and "Order Number". I need to generate a list of order combinations associated with a SKU and if that list also applies to another SKU generating a new row for each SKU order list combination. sample data below

Item Number (SKU)	Order Number
AC12TAR6	6010071
AC12TAR6	6010072
AC12TAR6	6010973
AC12TAR6	6034166
AC12TAR6	6034168
AC12TAR6	6034170
AGG12B6	6027364
AGG12B6	6029529
AGG12B6	6029530
AGG12B6	6032487
AGG12B6	6042748
BB3BF9	6018230
BB3BF9	6038288
BB3BF9	6038290
BB4BC6	6024689
BB4BC6	6043674
BB4BC6	6043808
BB4BF6	6010973
BB4BF6	6011877
BB4BF6	6013191
BB4BF6	6024913
BB4BF6	6025173
BB4BF6	6025182
BB4BF6	6029530
BB4BF6	6029763
BB4BF6	6032348
BB4BF6	6034166

Expected output

Item Number (SKU)	List
AC12TAR6	6010071;
AGG12B6	6010071;
BB4BC6	6010071;
AC12TAR6	6010072;6034170;
BB3BF9	6010072;6034170;
BB4BC6	6010072;6034170;
AC12TAR6	6010973;6034166;6034168;
AGG12B6	6010973;6034166;6034168;
BB3BF9	6010973;6034166;6034168;

[Anonymous]

Thanks for all the replies but I've figured out how to do it on SAP BO 

[v-jianboli-msft]

Hi @Anonymous ,

Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details to help us clarify your scenario? What is your rule to generate list? It seems that some SKUs have a list of expected outputs that contain order numbers which are not in the source table. 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

I don't understand the rules behind your expected outcome.  Can you please explain them again?