Is there a way to select all of the cells with the same value? I have 3 quarters worth of data and every row has a year in column a (fy2011 or fy2012) and a quarter in column b (Q1, Q2, Q3, Q4).
FY2011 Q4 FY2011 Q4 FY2011 Q4 FY2012 Q1 FY2012 Q1 FY2012 Q1 FY2012 Q2 FY2012 Q2 FY2012 Q2
What I need to do is split the data and put each quarter in it's own column, by Quarter. (the data is on a filtered range to make things tougher).
Thanks for your help!
Sorry, I didn't specify. I need to build this out in VBA. I need to go from (listed in order of date):
FY2011 Q4 A 1 FY2011 Q4 B 2 FY2011 Q4 C 3 FY2012 Q1 A 1 FY2012 Q1 B 2 FY2012 Q1 C 3 FY2012 Q2 A 1 FY2012 Q2 B 2 FY2012 Q2 C 3
To (grouped by partner):
Q4'11 Q1'12 Q2'12 A 1 1 1 B 2 2 2 C 3 3 3
Even if you need to give as raw data,you can create a pivot table and then paste as value .
Asadulla Javed, Kolkata[********Please do not forget to click “Vote as Helpful” if any post helps you and "Mark as Answer" if it solves the issue.******]