T-SQL：将列值移动到行值

I want to have a case statement (or one you suggest) produce multiple results and those multiple results are reflected in the output. However, using the example at the bottom, I do not get the desired results. Thanks in advance.I want to have a case statement (or one you sug