Forum Discussion
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.
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.