Template · Clean · Opening soon

Unpivot wide data into rows

Turn a sheet with a column per month into one row per month, the shape charts, pivots and dashboards need.

Book a demo

You bring

Wide table6 rows

Label columnsColumns to turn into rows

Mammoth does the work

You get

One table36 rows

A long table: one row per label and period, with its value.

Label columnsPeriodValue

Not a spreadsheet to fill inIt is a ready-made workflow in Mammoth. You bring the files, and it does the work.
Your files, as they areUpload a file or connect a source. Your column names do not have to match.
Runs again by itselfWhen new data arrives, every step runs again and the result updates.

What you get back

The real result of this template, run on sample data.

Unpivot wide data: the resultSample data36 rows

Account	Period	Value
Revenue	May 2026	26,734.32
Cost of sales	May 2026	13,739.13
Salaries	May 2026	19,522.17
Rent	May 2026	18,780.64
Marketing	May 2026	28,728.37
Software	May 2026	2,873.28
Revenue	Jun 2026	37,121.97
Cost of sales	Jun 2026	10,579.19

36 rows in the result · made from 6 input rows · first 8 shown. Sample data: illustrative figures, not business results.

What does unpivot mean?

Unpivoting turns columns into rows: a table with Jan, Feb and Mar columns becomes one with a Period column and a Value column.

How it works

How to use the unpivot wide data template

1Bring your dataConnect a source, or upload a file.
2Check the columnsMammoth matches each column the template needs and asks only when it is unsure.
3Choose where it goesA table, a sheet, or a dashboard. It rebuilds on every refresh.

See the exact columns and steps ›

What it needs

A wide table: label columns, plus a column per month (or year, or store)

Wide table

Label columnsColumns that name each row, kept as they are.
Columns to turn into rowsOne per month, year or store.

The steps it runs

1Match columns
2Turn the columns into rows

Every step is an ordinary Mammoth step you can open and change.

Unpivot wide data: questions

Does it update by itself?

Yes. The template becomes an ordinary workflow in Mammoth. When your data refreshes, from a connector, a scheduled pull or a new file, every step runs again and the result table updates.

Can I change the steps?

Every step is an ordinary Mammoth step you can open and edit. Mammoth remembers which steps came from the template, so an update never overwrites your changes.

Do my column names have to match?

No. You point the template at your columns once. Mammoth suggests a match for each one and asks only when it is unsure.