Hi,
I am trying to identify the best way to sort and present some data as follows:
This is just a few rows but consider plenty rows of the same, Date, Bottle colours and Litres of water in each. With so many rows firstly how can I:Date Bottle Water(litres)
01/02/2018 Green 5
03/02/2018 Red 10
10/02/2018 Green 8
10/02/2018 Red 9
15/03/2018 Blue 6
16/03/2018 Red 20
06/04/2018 Green 4
10/05/2018 Blue. 3
- Get rid of typo issues, such as row 9 you see "Blue.", but in actual fact the "." is a typo.
- Then I also want to be able to merge total Litres that are with the same month, so I just want to see one row for "Green" for each month, so for February just one row for Green with Total Water 13 Litres.
- Then in addition I want to be able to graph these with month along the X axis and Water litres along the Y axis with lines for each bottle colour, is a pivot cable the quickest way?
Thanks
Bookmarks