我的PIVOT返回每行中具有数据透视列值的重复行

I am having an issue I have seen others with similar issues, but the answers for those don't seem to apply to my situation. This is my first Question, so forgive me in advance for any formatting issues and thanks for any insight you can provide.I am having an issue I have seen others with si