I’m trying combine items in a data table and their values in the next cell.
I can disregard the first column, date doesn’t need to be considered at this point.
Example Data table:
Column0 | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
11/1/2021 | Task1 | 4 | Task1 | 3 | Task1 | 1 | ||||||
11/2/2021 | Task3 | 4.5 | Task2 | 1 | Task3 | 8 | Task1 | 3 | Task3 | 2 | ||
11/3/2021 | Task1 | 4 | Task2 | 2 | Task3 | 4 | Task1 | 2 | ||||
11/4/2021 | Task1 | 5 | Task3 | 5 | Task2 | 1 | Task1 | 3 | Task3 | 1.5 | ||
11/5/2021 | Task1 | 1.5 | Task3 | 9 | Task3 | 3 | Task1 | 1.5 | ||||
11/6/2021 | Task3 | 5 | ||||||||||
11/7/2021 | Task1 | 6 | Task2 | 6 | Task1 | 8 | Task1 | 3 | ||||
11/8/2021 | Task2 | 5 | Task1 | 3 | Task1 | 1 | ||||||
11/9/2021 | Task3 | 4.5 | Task2 | 1 | Task3 | 6 | Task3 | 1 |
Example Output:
Column0 | Column1 |
---|---|
Task1 | 46 |
Task2 | 16 |
Task3 | 50 |