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!!!
Solved! Go to Solution.
Thank you so much for the simple solution.
I tried using Mode instead of average but I think its the same thing.
Will revert if I run into any issues with different data.
Much appreciated!
Does anyone know how I can dynamically sort the A B C in my desired order (they are actually not A , B , C, so alphabetical sorting doesn't work) so that whatever data I input, as long as the row values under TYPE column always have the same wording, it will sort accordingly?
Hi @mjh418 ,
Can you provide an example of the values you have instead of A,B and C and the expected output please? That would help I believe.
Thanks
Angelos