Forum Discussion
Changing row/column orientation (?)
Ok, I'm not sure how to word this... I have a huge list of items that all have several ROWS each. Each row of information for the products varies only by quantities and price. Example...this...
ppaccounting The attached file contains two possible solutions. One with old-fashioned indexing formula. The other with modern dynamic array functions UNIQUE, FILTER and TRANSPOSE. The yellow coloured cell are the ones that contain formlae.
Both can be improved by using a structured table for the data or named ranges. But in this example I kept the direct cell references so that you can figure out how it all works.
Edit: Since you mentioned to work with hundreds of products, consider using Power Query. Added another file with an example.