Pulling specific criteria in a cell and putting it into a column

Below is an example of my data. I am hoping to get the row with "**660000 Salaries: Inscope" into the column. See below for after results. The"**660000 Salaries: Inscope" cell can vary with different accounts, however it is always consistent with "**" in the cell.

The "**" cell is a total cell for the cells listed above. How can I create a flowchart that can do this. Thanks everyone for their help!

Before

Screenshot 2025-06-02 110042.png

AFTER

Screenshot 2025-06-02 110304.png

Workflow

Accepted answers

abacon

Ah that is very helpful, this workflow does what you are looking for. There are definitely other ways to do this too for the more advanced with Regex!

Bacon

Specific Criteria Workflow.yxmd

binu_acs

@jessy_chow one way of doing this

cost_CEnter_02062025.yxzp

jessy_chow

Thanks everyone for your help! Both methods worked!

All comments

abacon

@jessy_chow Does filtering out the field you are looking for with a Contains([column name], "*") then using an append fields tool after the filter get you what you want?

Bacon

jessy_chow

Thanks for the suggestion, however it doesn't. It ends up adding all the cells with "* " to all the cells and doesn't it each time with each account containing "**" so it like multiples my data.

Shown is how account * 600000 Salaries: Inscope is applied to the Source_F2 column, then * 600010 Salaries: Mgmt is applied to all the data in Source_F2 again.

Screenshot 2025-06-02 120132.png

binu_acs

@jessy_chow one way of doing this

cost_CEnter_02062025.yxzp

jessy_chow

Thanks everyone for your help! Both methods worked!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703