Hello everyone
I have a Room# and follow-up dates spreadsheet that looks like this:
Room# 1 Month 3 Month 6 Month 9 Month
3456 7/14/2013 9/14/2013 12/14/2013 3/14/2014
1587 8/1/2013 10/1/2013 1/1/2014 4/1/2014
0164 9/11/2013 11/11/2013 2/11/2014 5/11/2014
Is there any way to change the format to something like this:
Room# Follow-up period Date
3456 1 Month 7/14/2013
3456 3 Month 9/14/2013
3456 6 Month 12/14/2013
3456 9 Month 3/14/2014
1587 1 Month 8/1/2013
and so on ......
If it's possible i really appreciate your help. Thanks
Bookmarks