How to add specific items within a column to create a new item within that column?

[apaicanada]

Hi All,

I am trying to add specific items within a column with each other to create a new item. This is what my data looks like:

Dates	Commodity	Units	Value
2018-09-12	2x4 R/L (Mid-week)	USD/Ton	12
2018-09-12	2x4 R/L (End-week)	USD/Ton	14
2018-10-12	2x4 R/L (Mid-week)	USD/Ton	16

I would like it to look like this:

Dates	Commodity	Units	Value
2018-09-12	2x4 R/L	USD/Ton	26
2018-10-12	2x4 R/L	USD/Ton	16

Any ideas or suggestions? Any and all ideas are really appreciated!

Thank you so much,

Akarsh

[fmvizcaino · Accepted solution]

Hi @apaicanada ,

I have used a left function to eliminate information you don't need in commodity column and summarize the data.

Let me know if that works for you.

Best,

Fernando Vizcaino

[JosephSerpis · Accepted solution]

Hi @apaicanada I mocked up a workflow let me know what you think?