Hello, I have been struggling with using transpose to perform the action below. Hopefully someone can help.
I have the following input where each row represents one person. Each person can choose option A, option B, or both.
I would like to change to have each option chosen on a new row. For example, John Doe chose a Bike and a Car so row 1 would be for the bike and row 2 would be for the car. As you can see below, regardless of which options are chosen, they are always displayed in the same column "Option", with the respective costs in the next two columns. There are also setting columns which only relate to the specific option and can also be blank or filled.
Output:
Could you please help me figure out how I can make this change using transpose or another method. I have also attached the .yxmd file with input and output as shown in the screenshots. Thanks in advance :)
P.S. So far, I have tried using transpose on individual columns and then using join but I still don't get the right output as above.
Solved! Go to Solution.
Thanks guys! Both work as intended :).
Yes, I already had mine built and looked at Alex's after. His is better 😉