How to use the Unpivot Table Tool.
Unpivoting preserves identifier columns while turning repeated headers into values. Check that the headers actually represent the same kind of measure.
Make the workflow fit your task.
Identify columns that describe a record and columns that repeat the same measure over periods or categories. Keep the identifiers fixed while turning the repeated headers into values. Specify how blanks should be handled and compare totals before and after.
- What you provide
- Wide table and identifier columns.
- What you get
- Long-form records preserving row identities.
See the input and the result.
Illustrative input and output · a teaching example, not a live WebAct run
Example input
Unpivot Jan and Feb, retain product as the identifier. CSV input: product,Jan,Feb A,10,12
Completed example
product,month,value A,Jan,10 A,Feb,12 Check: 10 + 12 = 22 before and after; no blank measurements in this example.
Load this input into the prompt, then copy it to WebAct to try the task. Your result may differ from the illustration.
Decisions and troubleshooting.
Can revenue and headcount columns be unpivoted into one numeric field?
Only with an explicit measure label and units. Mixing different measures without that context makes the result ambiguous.
Why did unpivoting create unexpected missing-value rows?
Check the chosen blank policy and selected measure columns. Preserve or remove missing entries deliberately, rather than accepting a default silently.
Try it with your own source.
Replace the example with your material in the task prompt. Keep the requirements you need, then copy the task into WebAct.
Customize and copy the task ↑