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

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

20211208 - Transpose.yxmd