Oct 15 2020 04:14 AM
SolutionI'd do with Power Query - query the source; group by Item Number returning lists of Item Codes without aggregation; expand it columns; return result back to the sheet.
Oct 15 2020 04:14 AM
SolutionI'd do with Power Query - query the source; group by Item Number returning lists of Item Codes without aggregation; expand it columns; return result back to the sheet.