Pivot Tables

[excel_user1]

I am trying to create a pivot table that will consolidate information about a single data point: # of visitors (people) by country and browser type.

For example, for the UK, there are a total of 100 visitors. 33 of these are using IE 6, 34 are using IE8, and 33 are using Google Chrome. My excel form lists this information accordingly:

Country - Browser - Visits
UK - IE6 - 33
UK - IE8 - 34
UK - Chrome - 33
Japan - IE4 - 27
Japan - IE6 - 5
Japan - Chrome - 4

I'd like to get it to display like this:

Country - Browser 1 - Browser 2 - Browser 3 - Total
UK - 33 - 34 - 33 - 100
Japan - xx -xx - xx - xx

[thingssocomplex]

I think I understand what you want to do create the pivot table and put the country in the row section, Browser in the Column section and visits in the value section!

[malnahar]

I am trying to create a pivot table that will consolidate information about a single data point: # of visitors (people) by country and browser type.

For example, for the UK, there are a total of 100 visitors. 33 of these are using IE 6, 34 are using IE8, and 33 are using Google Chrome. My excel form lists this information accordingly:

Country - Browser - Visits
UK - IE6 - 33
UK - IE8 - 34
UK - Chrome - 33
Japan - IE4 - 27
Japan - IE6 - 5
Japan - Chrome - 4

I'd like to get it to display like this:

Country - Browser 1 - Browser 2 - Browser 3 - Total
UK - 33 - 34 - 33 - 100
Japan - xx -xx - xx - xx

Hi , Please check attached , is this what you are looking for?

Regards