PivotTable Reversal
An Excel file that teaches how to perform Operating on Common Data in Two Lists operation.
Excel Pivottable Reversal
Row and column headers are being moved. Data dependencies are being preserved during the transfer. Array formulas are maintaining the connection. The new table format is being made suitable for reporting. The process is being automated.
Hope it is useful.