Feb 21 2022 01:31 PM - edited Feb 21 2022 01:52 PM
Hello,
So I'm trying to list mean values for two different sources and separate them by year to make a graph.
This is what it looks like:
Source | Year | Mean |
X | 2015 | 6 |
Y | 2015 | 7 |
X | 2014 | 3 |
Y | 2014 | 5 |
(years continue deceasing)
and this is what I want it to look like:
Year | X | Y |
2015 | 6 | 7 |
2014 | 3 | 5 |
2013 | 9 | 4 |
Say I had mean values going back a thousand years, is there a way to quickly group them all together and list them like this? The layout is the same as the first table, always "X" then "Y" and the names never change either always "X" or "Y". (If I have to do this one cell at a time then no big deal but I figured I'd try saving myself some time and learn something new)
Thanks!
Feb 21 2022 01:38 PM
Feb 21 2022 01:43 PM
You could create a pivot table based on the table.
Add Source to the Columns area, Year to the Rows area and Mean to the Values area.
You can turn off the Grand Totals of the Pivot table if you like.
Feb 21 2022 01:47 PM
Feb 21 2022 01:49 PM
Click anywhere in the pivot table.
Activate the Design tab of the ribbon.
Select Grand Totals > Off for Rows and Columns.
Feb 21 2022 01:51 PM