Using the dataset below as an example. I need to be able to create a new row for each condition for each ID
ID | Name | Condition 1 | Condition 2 | Condition 3 | Condition 4 | Condition 5 |
101 | Test 1 Name | Chronic Medical Condition | Learning disability | Attachment difficulties | ||
102 | Test 2 Name | Family discord | ||||
103 | Test 3 Name | Chronic Medical Condition | Neurological conditions | Attachment difficulties | ||
104 | Test 4 Name | Chronic Medical Condition | Neurological conditions | |||
105 | Test 5 Name | Learning disability | Family discord |
Like this:
101 Test 1 Name Chronic Medical Condition
101 Test 1 Name Learning disability
101 Test 1 Name Attachment difficulties
102 Test 2 Name Family discord
103 Test 3 Name Chronic Medical Condition
103 Test 3 Name Neurological Conditions
103 Test 3 Name Attachment difficulties
Etc.
Please and thank you.
Paul
Solved! Go to Solution.
Hi,
You can accomplish this using the Transpose Tool along with a filter. I've attached a sample workflow below:
You may not need the cleaning step, and can potentially sort on Null() instead of looking for empty records, depending on the input data.
Let me know if this helps, or you need clarification.
Thank you kindly! Works like a charm.