hello, i have a data set that looks like following below. i want to bring in the columns that show "yes" "No", how would i do that. so in the example below i would want the pivot table to show John doe RPE 1 Growth 1 week "yes" and 2nd row would show Jane Doe RPE 4, Growth 1 week "no"
Name | RPE | 1 week | Growth 1 Week |
John Doe | 1 | 323 | Yes |
jane doe | 4 | 0 | No |