Unpivot Excel columns: long to wide data. 1 click. Optipe DTS → Power Query no code!
The Unpivot Columns in Excel application of Optipe Data Tools Suite lets you unpivot or rotate columns with data spread in a 2D matrix into a flat table with 1 click. The resulting table is perfect as a database for pivot tables. Without formulas or Power Query.
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.
See also:
Examples:
Video Example. Unpivot columns.
