i have a column with codes. Each code has a different values. I need to summarize each values. I tried it with cell splitter and then cell replacer with another table for the values. And then column formula for the total. But this is wasteful. Is there a easier way to do it? Maybe a script where I say: “read the cell and then give each code a value, after it summarize the values?”
I hope you understand my problem.
All the best