Split column value from Sheet1 and insert as row in sheet2

Hi,

I am new to excel macro programming and need help to get rid of below requirement. Any help would be really appreciable...

I have a comma separated data inserted in single column (A) of my worksheet (sheet1) in my excel workbook. I want to split the data based on the delimiter (,) and want to create new rows of the splitted data in another worksheet (sheet2) of my workbook.

For example,

Sheet1 of excel can have data till Nth Row. Raw data looks like.... (In Sheet1, Column A)

Row1 - Cricket,Baseball,Chess
Row2 - Football,Foosball,Hockey
.
.
.
RowN - Blah,Blah,Blah

And output data should look like... (In Sheet2, Column A)
Cricket
Baseball
Chess
Football
Foosball
Hockey
Blah
Blah
Blah

Hope I was able to explain my need.

Please check the attached excel for example raw and output data. Click here Test.xls

Thanks in advance!