Excel VBA Help

I am new to Excel Macro and i was given the task with the following excel data

Date Brazil Turkey Italy Panama Lithuania
3/15/2014 110 47 192 0 2
3/16/2014 118 54 179 0 7
3/17/2014 72 22 96 0 1
3/18/2014 17 20 60 2 2
3/19/2014 19 17 57 0 1
3/20/2014 15 21 52 0 2

I am to create a Macro so the ending result for each Date like such.I have looked up various of ways to do it, but cant seem to find a way. Thank you very much

Date Country Downloads
3/15/2014 Brazil 110
3/15/2014 Turkey 47
3/15/2014 Italy 192
3/15/2014 Czech Republic 19
3/15/2014 Panama 0
3/15/2014 Lithuania 2
3/15/2014 Costa Rica 6
3/15/2014 Luxembourg 1