When to transpose rows and columns instead of unpivoting
Distinguish a table orientation change from a wide-to-long reshape, then choose the header treatment and inspect preserved cell values.
About 3 min read
Step-by-step help for specific tasks with UseFreeTools, including examples, settings and checks before you use the result.
Distinguish a table orientation change from a wide-to-long reshape, then choose the header treatment and inspect preserved cell values.
About 3 min read
Reshape a wide monthly table into a long table while preserving identifiers, naming the new fields and deciding whether empty values should create rows.
About 3 min read
Choose row, column and value fields for a pivot, distinguish missing groups from zeros and verify that the aggregate matches the intended question.
About 3 min read
Inspect the table, apply only the cleanup rules your importer needs and verify identifiers and the full export.
About 3 min read
Preserve leading-zero identifiers, choose text or inferred values deliberately and verify the actual JSON rows and types.
About 3 min read