Conditional Formatting/Sums

[nwatzlaf]

Hi there,

This is what my data currently looks like

Vendor A     50-Empty     2

Vendor A     75-Inbound   3

Vendor A     60-Outbound 2 

Vendor A      40-Dock Door 4

This is what I want it to look like

Vendor A     Empty  2

Vendor A     Utilized 9

Any help is greatly appreciated.

Thank you!

[atcodedog05]

Hi @nwatzlaf 

Can you provide the logic on how you are arriving at the output.

[nwatzlaf]

So any category other than empty is summed together.

[atcodedog05]

Hi @nwatzlaf 

Here is how you can do it.

1. Split the string into columns using Regex tool parse method.

2. Data cleanse tool to remove leading & trailing spaces

3. Formula to categorize empty & utilized

4. Summarize groupby vendor, category & sum of value

5. Displaying as single string

Hope this helps 🙂