I am trying to set up a pivot table and everytime a way i do it, it is not happening the way i want..
below is the excel worksheet i am getting.
Title City State 1/24/2013 1/25/2013 1/26/2013 1/27/2013 1/28/2013
Monkey Spring Hill FL 7:10, 10:15. - - - -
Monkey New York NY 5:40, 8:00, 10:30. - - - -
Monkey New York NY - 5:40, 8:00, 10:30, 12:45 AM. - - -
Monkey New York NY - - 3:20, 5:40, 8:00, 10:30, 12:45 AM. - -
Monkey New York NY - - - 3:20, 5:40, 8:00, 10:30. -
Monkey New York NY - - - - 5:40, 8:00, 10:30.
Monkey Oak Creek WI 6:45, 9:10. 6:45, 9:10. 6:45, 9:10. 6:45, 9:10. 6:45, 9:10.
Monkey Kailua HI 10:10 - - - -
Monkey Kailua HI - 8:00, 10:10. - - -
Monkey Kailua HI - - 1:30, 8:00, 10:10. - -
Monkey Kailua HI - - - 1:30, 8:00. -
Monkey Kailua HI - - - - 8:00, 10:10.
Monkey Tempe AZ 12:00, 2:20. - - - -
Monkey Pleasant Grove UT 9:30 - - - -
Monkey Tucson AZ 12:10, 2:40, 5:10, 7:45. - - - -
Monkey Tucson AZ - 12:25, 3:00. - - -
Monkey Tucson AZ - - - 12:25, 3:00. 12:25, 3:00.
Monkey Lancaster CA 2:15, 4:50. - - - -
Monkey Victorville CA 12:10, 2:45, 5:15, 7:50. - - - -
i want to have 1 row for each city and state and in that same row have the times for each day.
is this possible.. is the worksheet am working from corupted?
I want to put it into tabular form..and am doing in classic pivot table. just as i need a worksheet with the all time time put in one row.
Title City State 1/24/2013 1/25/2013
Monkey Kailua HI - -
8:00, 10:10.
10:10:00 AM -
Lancaster CA 2:15, 4:50. -
New York NY - -
5:40, 8:00, 10:30, 12:45 AM.
5:40, 8:00, 10:30. -
Oak Creek WI 6:45, 9:10. 6:45, 9:10.
Pleasant Grove UT 9:30:00 AM -
Spring Hill FL 7:10, 10:15. -
Tempe AZ 12:00, 2:20. -
Tucson AZ - -
12:25, 3:00.
12:10, 2:40, 5:10, 7:45. -
Victorville CA 12:10, 2:45, 5:15, 7:50. -
as you can see no problem till i get to to a city with more the one dat with a time in it..
Please help..
Bookmarks