rowlane

Home / Tools / Wide-to-long reshaper

Reshape · Browser based

Wide-to-long reshaper

Unpivot selected columns into attribute/value records while repeating optional identifier fields. Blank values stay visible as rows.

Fictional sample loaded for demonstration. Your file is not sent to a Rowlane server.

1. Bring in a table

CSV or TSV · UTF-8 text · up to 5 MiB, 20,000 records, and 100 columns

All values stay text, including IDs like 0017.
Quoted commas, quotes, and line breaks are preserved. Choose the delimiter if detection is wrong.
Columns to reshape
Identifier fields (optional)
Value fields to unpivot

Each selected value field creates one output row per input record. Blank values are retained.

Loading table…

What this tool does

Each selected value column creates one output record for every input record. Identifier fields repeat on those records, followed by an Attribute field containing the source header and a Value field containing the original cell text.

How to use it

  1. Choose zero or more identifier fields that should repeat on each output record.
  2. Choose one or more value fields to unpivot. A field cannot be both an identifier and a value.
  3. Reshape, review the generated Attribute and Value fields, and download the new CSV.

2. Check the input

Confirm the header and a few records before applying a rule.

Questions

What to expect

What are identifier fields?

They are values such as region, account, or date that stay attached to every generated row. You can choose none when every field should be unpivoted.

Are numeric-looking values converted?

No. Every cell remains text, including IDs with leading zeroes and numbers that need later validation.

Review the destination rules. A valid CSV or a clean report does not guarantee that another system will accept the file. Keep your original and verify any export before importing it.