0

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

enter image description here

Now I want to get below result with Pivot tables:

enter image description here

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.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Loghman Mohamadzadeh
  • 137
  • 7
  • Possible duplicate of [creating a calculated field in excel pivot table based on an item in a column](http://stackoverflow.com/questions/30224929/creating-a-calculated-field-in-excel-pivot-table-based-on-an-item-in-a-column) – Abhijeet Feb 28 '16 at 15:52
  • Abhijeet I think you didn't understand me, please read the question again. It's totally different with this thread. – Loghman Mohamadzadeh Feb 28 '16 at 16:03
  • Pivot tables work far better with normalized data. Can you get your data into two columns: one with city name and the second with the number? – Doug Glancy Feb 28 '16 at 16:17
  • You right [Doug Glancy](http://stackoverflow.com/users/293078/doug-glancy), but my customer data is like that. – Loghman Mohamadzadeh Feb 28 '16 at 16:33

1 Answers1

1

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

Community
  • 1
  • 1
pnuts
  • 58,317
  • 11
  • 87
  • 139