Transpose Multiple Columns into Repeating Rows

[YLYONG]

Hi All,

I have a data set that looks like this:

Type	Subsystem	27/06/2022	4/07/2022	11/07/2022
Wood	ABC	8,122	8,151	8,152
PVC	ABC	102	85	223

To be converted into this:

Type	Subsystem	Week	Value
Wood	ABC	27/06/2022	8,122
Wood	ABC	4/07/2022	8,151
Wood	ABC	11/07/2022	8,152
PVC	XYZ	27/06/2022	102
PVC	XYZ	4/07/2022	85
PVC	XYZ	11/07/2022	223

I used "Arrange" but it doesn't seem to arrange the table correctly.

Thank you for your assistance.

[Jonathan-Sherman · Accepted solution]

Hi @YLYONG,

You could use the transpose tool to pivot your column headers to row labels:

I've attached my workflow for you to download if needed!

Kind regards,

Jonathan

[Jonathan-Sherman]

In terms of configuring the transpose tool itself there are two sections, Key Columns and Data Columns. Tick fields in the Key Columns section to tell Alteryx not to pivot the fields, this should untick the fields from the Data Columns section (but do always check this is the case!)

Kind regards,

Jonathan