B12.jpg
Professional Applications for Microsoft Excel
EnglishEspañol (spanish formal Internacional)PortuguêsDeutsch

Optipe Data Tools Suite - Unpivot Columns

The Unpivot Columns application of Optipe Data Tools Suite allows you to rotate or unpivot columns with data distributed in a two-dimensional array. The result table may be used as database for Pivot Tables.

Data Tools Suite Unpivot Columns

Data Tools Suite Unpivot ColumnsUse this application to:

  • Prepare data so they can be read as a database in Pivot Tables.
  • Transform data from systems, the Internet or other PivotTable reports.

Features:

  • Easily select fields or columns to unpivot.
  • Skip blanks and/or zeros.
  • You can define names for the resulting columns (fields and values​​ names).
  • To select a consecutive group of fields, click the first item, press and hold down the Shift key, and then click the last item.
  • To select non-consecutive fields, press and hold down the Ctrl key, and then click each item that you want to select.
See also:
BuyNow

Examples:

Video Example. Unpivot columns.

Copyright © OPTIPE - Optimize Time Performance. Professional Applications for Microsoft Excel 2017

Template by Joomla Themes & Copywriter.