Hi all!
I would like to transpose some records from this format where the number after the date is the identifier:
column 1 column 2
Sunday, January 23, 2011 0
Saturday, September 11, 2010 0
Saturday, January 09, 2010 0
Monday, August 31, 2009 0
Monday, October 17, 2011 1
Thursday, April 21, 2011 1
Wednesday, November 10, 2010 1
Friday, August 27, 2010 1
Friday, April 30, 2010 1
Thursday, February 04, 2010 1
Tuesday, November 03, 2009 1
Monday, September 28, 2009 1
Monday, July 06, 2009 1
To this format:
column 1 Column 2 Column 3 Column 4
0 Sunday, January 23, 2011
1 Monday, October 17, 2011 Thursday, April 21, 2011
This just transposes records which occur in 2011. Any suggestions?
Thanks so much!
Bookmarks