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!
