Arrange cells dynamically

[shruthitulsi]

Hi ,

I have a query output stored in a range.
which has years in the first column
i have to arrange the data based on the year , leaving empty cells if a particular year is not present.

SOURCE DATA( Dynamic , recieved from a QUERY)

2001 10 30 50 20 11 34
2006 11 10 53 10 23 45
2009 12 20 67 90 0 3
2010 13 40 11 4 10 11

This needs to be arranged like this

2001 10 30 50 20 11 34
2002
2003
2004
2005
2006 11 10 53 10 23 45
2007
2008
2009 12 20 67 90 0 3
2010 13 40 11 4 10 11

Kindly Look into the workbook attached.
Awaiting Help....



Thanks In Advance,
Shruthi