ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I list every data combination from a large pivot table? (https://www.excelbanter.com/excel-discussion-misc-queries/185158-how-can-i-list-every-data-combination-large-pivot-table.html)

zjjason

How can I list every data combination from a large pivot table?
 
I've got 125 line items (text) I need to multiply out and show every
combination in 2 columns (15625 possible line item combinations). In
addition, I will need to run formulas for each row so Merged Cells do not
work. My closest attempt with reference data arrays and lookup functions
could work, but I will need to c/p too much. I'd like to just fill-down my
formulas.

Herbert Seidenberg

How can I list every data combination from a large pivot table?
 
Use reverse Pivot Table.
No formulas needed:
http://www.freefilehosting.net/download/3g555



All times are GMT +1. The time now is 11:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com