"Unpivot" Data transformation.

[D12monkey]

I must be having a bad day. I can't for the life of me remember how to do a data transformation/Unpivot in alteryx.

I have data that comes in the follow format.

Field1	Field2	Field3	Field4
1	(null)	(null)	(null)
(null)	2	(null)	(null)
(null)	(null)	3	(null)
(null)	(null)	(null)	4
a	(null)	(null)	(null)
(null)	b	(null)	(null)
(null)	(null)	c	(null)
(null)	(null)	(null)	d

and I need it in this format.

Field1	Field2	Field3	Field4
1	2	3	4
a	b	c	d

I can remember how to do it with a multirow formula, but I have 50 some-odd columns and don't want to add 50+ multi formula tools.

And help would be appreciated.

Thanks!

[Jonathan-Sherman · Accepted solution]

Hi @D12monkey,

I think this is what you're trying to achieve?

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[grossal · Accepted solution]

Hi @D12monkey,

don't worry, we got your back! And here is how to do it:

What happens:

- Transpose everything into Rows

- Filter out all null values

- Add a custom Counter grouped by your Field Name values (Multi-Row-Formula)

- Cross Tab everything back

- Remove the "Counter" Column (Select)

Sample Workflow attached. Let me know if this solved your problem.

Best

Alex

[D12monkey]

Thanks!