Forum Discussion

craygoza92's avatar
craygoza92
Copper Contributor
Dec 17, 2021
Solved

2 COLUMNS, DUPLICATE ENTRIES

Good afternoon, this is my first post;   I've got 2 columns, 1 with product names (Sku) and 1 with product locations (Location). Products have different locations and when running a report it gives...
  • Riny_van_Eekelen's avatar
    Dec 18, 2021

    craygoza92 I would go for a Power Query solution as demonstrated in the attached file. 

     

    Converted a small portion of your list into a structured table and added a column to count the number of occurrences for any specific SKU. This is used in PQ to split the locations per SKU into the correct number of columns. You can do that within PQ as well, but this way it's easier to follow.

     

    Add your real data into the blue table (called Table1). The formula in the Count column should fill down automatically. Press Refresh All on the Data ribbon. The green table should update instantly. See if this works for you.

Resources