Hi,
I have a spreadsheet that keeps track of my team members travel information (attached). I would like to create another another tab that organizes the travel information by month in this fashion:
January
Tom | Thailand | Bangkok | Meeting 2 | 10 Jan 2013 | 11 Jan 2013
John | Australia| Melbourne | Meeting | 24 Jan 2013 | 5 Feb 2013
Feb
Data of Feb travelers
March
Data of March travelers
I have included a sample of the data and a rough idea of how the tab is going to be like. Should I create a pivot table or is there another way of doing this? I would appreciate any advice on this since I've been doing trials and errors for the past week and still can't find any solution.
Thanks!
DL
Bookmarks