Paste Link Transpose in Excel

Jay Arthur
888-468-1537
303-756-9144
KnowWare International, Inc.
DBA LifeStar
2253 S. Oneida
Ste 3D
Denver, CO 80224

We work with companies
that want to fire up their profits using
Lean Six Sigma

Copyright © 2011

Paste Link and Transpose at the same time using the QI Macros for Excel

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 Data Transformation Tools and then Paste Link or Paste Link Tranpose.

The QI Macros will open a new sheet in your workbook with the data linked to the old sheet and transposed if you selected Paste Link Transpose. Here is an example of the above data transposed in a new sheet. (Note formula that links the data to cells in the original sheet named "box cox")

QI Macros Data Transformation Tools

• Box Cox Transformation
• Stack and Restack
• Get Sample From Table
• Paste Link and Paste Link Transpose
• PivotTable Wizard - Cross Tab
• Count Words in Selection
• Change Default Language
• Quick Keys On and Off
• Show / Hide Data Sheets

Other QI Macros and Control Chart Articles

The Paste Link Transpose function is just one of the tools included in the QI Macros for Excel SPC Software for Excel.

Download the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six Sigma

Download
QI Macros
30-Day Trial Now!

Or Buy It Now!