怎么根据逗号拆分多条数据

如何根据逗号拆分多条数据

    area                                            date

黑龙江,吉林,辽宁                                            2013-5-1

内蒙古,北京                                                 2014-1-1

福建,浙江                                                   2012-4-2

天津,河北,河南,山东,威海,青岛,哈尔滨,武清区                2015-3-16

*                                                        2014-9-12

辽宁,河南,威海,沈阳,大连                                   2015-2-1     

现在想得到的数据是，如何根据逗号拆分多条数据

area                                                date

黑龙江                                                      2013-5-1

吉林                                                        2013-5-1

辽宁                                                        2013-5-1

内蒙古                                                      2014-1-1

北京                                                        2014-1-1

福建                                                        2012-4-2

浙江                                                        2012-4-2

天津                                                        2015-3-16

河北                                                        2015-3-16

河南                                                        2015-3-16

山东                                                        2015-3-16