Need to restructure my data set. Any macro for this?

Hello,   I'm working with a large data set that outputs reports grouped by date, with territory values comma delimited in a single cell, as follows:          A              B 1  Date1     Territ...