Forum Discussion
2 COLUMNS, DUPLICATE ENTRIES
- 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.
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.
- craygoza92Dec 20, 2021Copper Contributor
Edit 1 - Nevermind, it worked, thanks!.
Edit 2 - Is there any guide that you can link me to so I can understand how this was achieved? Thanks again.
Thanks for your reply, tried using your sample file but I cannot get it to work, nothing happens when I hit refresh all, i get these windows:
- Riny_van_EekelenDec 20, 2021Platinum Contributor
craygoza92 The link below would be a good starting point.