Create new row for each value in fields (excluding nulls)

paulb1

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

tcroberts

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.

transposewithblanks.yxmd