Hello, I am trying to transform a column variable into several dummy variables with one row per ID. Here is the data I have: ID, Referral Type 1, Housing 1, Transportation 2, Food 3, Housing 3, Food 4, Transportation 4, Mental Health Here is the data I want: ID, Housing, Transportation, Food, Mental Health 1, 1, 1, 0, 0 2, 0, 0, 1, 0 3, 1, 0, 1, 0 4, 0, 1, 0, 1 Any advice would be greatly appreciated! Thanks 🙂
... View more