Creating a new column from filter

[ksmith4567]

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!

[atcodedog05 · Accepted solution]

Hi @ksmith4567 

Here is how you can do it.

Workflow:

Hope this helps : )

[ksmith4567]

Thank you!

[atcodedog05]

Happy to help : ) @ksmith4567 

Cheers and have a nice day!