Calculate sum of columns data in Excel Pivot table base on columns name

Question

I have some data in an Excel sheet, like this:

Now I want to get below result with Pivot tables:

As you can see I want to put the columns name's of the source data at the first columns of the pivot table and sum of each columns in the second one.

Any help highly appreciated.

Answer 1

Insert a new ColumnA, follow the process here, select output Table Columns B and C and pivot those. Relabel to suit.