Forum Discussion

LorenC1140's avatar
LorenC1140
Copper Contributor
Jan 07, 2020

Excel Help

Please see the attached screenshot of my spreadsheet. It was the only way I could explain what I need help on. Any help would be greatly appreciated. 

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    LorenC1140 

    You may do that with Power Query - query the source, merge with itself on ItemSku, remove duplicates on it, expand aliases as list, transform to new columns.