Paste Link Transpose in Excel
Paste Link and Transpose at the Same Time Using QI Macros Add-in
Excel provides a paste link and a paste transpose function, but it won't do both at the same time. The QI Macros Paste Link and Paste Link Transpose functions take any size table and paste link it into a new sheet. Both use formulas to prevent putting zeros instead of blanks in linked cells.
Here is how the Paste Link Transpose Function Works:
Just select your original data (6X6)
Then click on the QI Macros menu and select Restacking and then Paste Link Transpose:
QI Macros will transpose your data and paste and link it in a new sheet in your workbook. Here is an example of the above data transposed in a new sheet. If you click on any cell (i.e. C2) you will see the formulas linking that cell to the original data sheet.