Forum Discussion
Solved
Consolidate a worksheet with many columns to show only the cells that are used.
Hello, I have an exported item price list, which shows 4 different levels of pricing for every item that we sell. Each row has the Item SKU in column A, and the 4 prices are listed to the right ...
Anonymous66 I would do this with Power Query (PQ). Connect to the pricing table and flatten it with the Unpivot command. In the attached file you find a simple example, with a table containing only 3 categories. But the principle is the same for 13.
If you are not familiar with PQ or can't get it to work on the real pricing table, come back here.
Anonymous66 I would do this with Power Query (PQ). Connect to the pricing table and flatten it with the Unpivot command. In the attached file you find a simple example, with a table containing only 3 categories. But the principle is the same for 13.
If you are not familiar with PQ or can't get it to work on the real pricing table, come back here.
Thank you for your help! This works for my application 👍