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 👍
