Table Unpivot Workbench
Turn selected wide CSV measure columns into variable/value records without aggregating text.
Loading tool…
How to use Table Unpivot Workbench
Keep identifier fields on every long-form record while moving selected source column names into a new variable field. Output order follows source rows then your measure-column selection, and empty cells follow your explicit policy.
- Enter input, identifier columns, measure columns, variable output column, value output column.
- Choose the settings for table unpivot workbench, then run the tool.
- Review the result and any limitations before copying or downloading it.
Good to know
- 200,000 characters,100 input columns and5000 output records, counted before output construction.
- Values remain text. CSV export formula-protects hazardous cell prefixes; no type guessing,aggregation or locale conversion.
- Processing is local. Output is limited to 1,000,000 text characters unless a stricter file limit is stated.
Common questions
Will leading-zero values become numbers?
No. A source value such as001 remains text001 in the output.
Is this input sent to a server?
No. The application processes this input inside your browser tab and does not save it to persistent storage.
Keep going with related tools
All data →CSV Pivot Table
Group CSV records by row and column keys and compute a bounded count, sum or mean pivot.
DataCSV Multivalue Exploder
Expand a selected multivalue CSV cell into separate records while retaining every other column.
DataCSV Validator
Check CSV quoting and record widths, reporting row and column counts with header warnings.
DataText-cell Table Pivot
Reshape unique row-key and field records into a wide string table without numeric aggregation.
DataJSON Parent and Child Array Unnester
Create a relational CSV from one explicit child array while retaining parent/child record provenance.
DataMultirow CSV Header Flattener
Combine declared header levels into single field names with explicit blank-fill and collision policies.