Hi Community, I have a sample data set as follow:
before:
Order | Order Item | Machine A | Machine B | additional description 1 | additional description 1 cost | additional description 2 | additional description 2 cost |
372 | 10 | 100 | 200 | Machine D | 300 | Machine E | 500 |
372 | 20 | 150 | 50 | Machine C | 120 |
expected:
Order | Order Item | Description | Cost |
372 | 10 | Machine A | 100 |
372 | 10 | Machine B | 200 |
372 | 10 | Machine D | 300 |
372 | 10 | Machine E | 500 |
372 | 20 | Machine A | 150 |
372 | 20 | Machine B | 50 |
372 | 20 | Machine C | 120 |
hope it makes sense, I understand that we will need transpose, but the I don't have solution for dealing with "additional description 1, 2.." part,
so how to do that in alteryx formula?
Thanks
Solved! Go to Solution.
@Ryanz3653 The Arrange tool might help to make data shape into vertical for fields "Additional description...". Here is the example of how to utilize it.