Hi there I am trying to use a filter that contains string values to then create a new column with number values. Example data below:
I have the following:
Person | Fruit | Sales |
Ann | Apple | 100 |
Jeff | Orange | 200 |
Ann | Apple | 400 |
Ann | Orange | 500 |
I want to filter to just rows with Apple sales so that I can then summarize the data with Apple Sales being a new column rather than having a fruit flag:
Person | Sales | Apple Sales |
Ann | 1000 | 500 |
Jeff | 200 | 0 |
Is anyone able to assist? Thank you!
Solved! Go to Solution.
Thank you!
Happy to help : ) @ksmith4567
Cheers and have a nice day!