Create simple pivot table with Excel

Question

I am trying to create an Excel pivot table. I've got the following simplified table:

I want to create a pivot table looking as follows:

However, after experimenting with the pivot functions, I don't seem to be able to produce such a table. How do I accomplish this using Excel pivot table features (rows, columns, values,...)?

Answer 1

You need the data in a different table format:

Fuel    Year    Use
Coal    2015    0.2
Coal    2015    0.2
Coal    2015    0.2
Coal    2015    0.9
Coal    2020    0.7
Coal    2020    0.6
Coal    2020    0.4
Coal    2020    0.8
Oil     2015    0.8
Oil     2015    0.6
Oil     2015    0.6
Oil     2015    0.6
Oil     2020    0.8
Oil     2020    0.7
Oil     2020    0.7
Oil     2020    0.1

Then pivot table with

• Column Labels: Year
• Row Labels: Fuel
• Sum Values: Use

You'll get:

Sum of Use  Column Labels       
Row Labels  2015    2020    Grand Total
Coal        1.5     2.5     4
Oil         2.6     2.3     4.9
Grand Total 4.1     4.8     8.9

Answer 2

As stated by @Sir Adelaide, you need to reformat your data. One quick way of doing it is to use the unpivot add-in I've put online here.