I have the following data arrangement:
Three columns with codes and labels which have the same contents, e.g. 1=Washington, 2=New York, 3=San Francisco,...
Washington could be chosen in two or three columns.
I now want to rearrange it as it would be a multi code variable: One column for Washington, one for New York etc, each with codes 1 (for selected) and 0 (for not selected).
Is there any easy solution to this?
Thank you very much.
Go to Solution
This is not very complex, but it takes a few steps to do this interactively
View solution in original post
Wo, thank you very much for the quick response and you effort.
This solves the problem. I tried stacking and splitting, but did not get the result. With this approach (esp. step 3 and 4), it works perfectly.
There are no labels assigned to this post.