Stacking and Restacking Excel Data with QI Macros

Published: 27 August 2016
on channel: QIMacros
610
1

Data is rarely in the format or orientation needed for charting and analysis. Sometimes you need to stack or restack data to make it useful.
In this video you'll learn how to:
Paste Links with formulas that won't convert blanks to zeros
Paste Link Transpose
Stack or Unstack Columns of data
Restack any NxM matrix into another form
Unstack Data by Single or Multiple Labels

This video answers the questions:
1. Why do I need to reorder my data?
2. How do I reorder my data with QIMacros?


Watch video Stacking and Restacking Excel Data with QI Macros online without registration, duration hours minute second in high quality. This video was added by user QIMacros 27 August 2016, don't forget to share it with your friends and acquaintances, it has been viewed on our site 610 once and liked it 1 people.