i have 2 columns A = places B= dates of visit. I wish to eliminate the repeated places and sort the dates hotizontally.
I have been able to set up a pivot table where all the names are reduced to one but the date values are displayed in a column. I wish the dates to be displayed on the same row as the place ie london 25/1/2012 12/02/2012
Add a column into the table. Named as “date_type”.
In the “date_type” column, type in “date1”, “date2”,”date3”… for each place.
3. Insert the Pivot Table. Set the “Field List” as the picture.
4. For the “Values” part, left click the button “Sum of da…”, choose “Value Field Settings”. Choose the “Show Value As” tab, then choose “No Calculation”. Click the button “Number Format”, choose “Date”.
5. Select the whole Pivot Table, right click and choose “PivotTable Options”, choose “Total&Filters”,uncheck the “Show grand totals for rows” and “Show grand totals for columns”.Click OK.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.