Forum Discussion
Group codes and sum their values from a single text string
Hi, I've got a text column with this format "Oper A - 8.5, Oper B - 3.0, Oper A - 2.5, Oper C - 5.0, Oper B - 5.0" to define the operations that happened in 24 hours. Basically time is separated ...
Hi Anonymous
You can split those into their own rows using the same split function. Just click the advanced option in the Split dialog and set something like this for your column.
Hi Anonymous
You can split those into their own rows using the same split function. Just click the advanced option in the Split dialog and set something like this for your column.
Thank you Phil_Seamark,
I think I had in my mind an easiest way to calculate "on-the-fly" (without creating extra columns) the values after the commas and group them by the operation codes. I'll try the splitting instead. Thank you again for your help!