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

Use 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.

Examples: