I have a column (e.g. named C) with identical values that I want it to be part of the Row of "Type".
So I want the column Header C to be one of the Type (A,B,C, so there will be 3 rows of January data), and the just one value(they are identical) of C to go under Value Total column only.
If it makes easier, I don't mind having a separate column for a New Value Total if it can't be helped.
Current state:
| Date | Type | Value1 | Value2 | Value Total | C |
| 2020-01-31 | A | 2 | 3 | 5 | 1 |
| 2020-01-31 | B | 3 | 5 | 8 | 1 |
| 2020-02-29 | A | 4 | 2 | 6 | 2 |
| 2020-02-29 | B | 2 | 1 | 3 | 2 |
| 2020-03-31 | A | 1 | 5 | 6 | 3 |
| 2020-03-31 | B | 5 | 7 | 12 | 3 |
Desired Outcome:
| Date | Type | Value1 | Value2 | Value Total |
| 2020-01-31 | A | 2 | 3 | 5 |
| 2020-01-31 | B | 3 | 5 | 8 |
| 2020-01-31 | C | | | 1 |
| 2020-02-29 | A | 4 | 2 | 6 |
| 2020-02-29 | B | 2 | 1 | 3 |
| 2020-02-29 | C | | | 2 |
| 2020-03-31 | A | 1 | 5 | 6 |
| 2020-03-31 | B | 5 | 7 | 12 |
| 2020-03-31 | C | | | 3 |
Its harder than I thought to achieve this.
I would greatly appreciate if someone can offer me a simple as possible solution. Thank you so much for your time and help!!!
