Convert table into list format (live)

[AndyDevine1]

Hi, some of the team are updating data that is in the format below (Table A):

Table A
Country Region Metric 01/02/2018 02/02/2018 03/02/2018 04/02/2018 05/02/2018 06/02/2018 07/02/2018
UK Region1 Sales 1 2 3 4 5 6 7
UK Region2 Sales 6 6 6 6 6 6 6
US Region1 Sales 11 12 13 14 15 16 17
US Region2 Sales 11 12 13 14 15 16 17
UK Region1 Rev 1 2 3 4 5 6 7
UK Region2 Rev 6 6 6 6 6 6 6
US Region1 Rev 11 12 13 14 15 16 17
US Region2 Rev 11 12 13 14 15 16 17


Others need it in Table B format below...
When the data in Table A is updated, any updates need to be reflected in Table B.
I've experimented with sumifs and indexes...

If you can please provide a solution, I would be very grateful

Country Region Date Sales Rev
UK Region1 01/02/2018
UK Region1 02/02/2018
UK Region1 03/02/2018
UK Region1 04/02/2018
UK Region1 05/02/2018
UK Region1 06/02/2018
UK Region1 07/02/2018
UK Region2 01/02/2018
UK Region2 02/02/2018
UK Region2 03/02/2018
UK Region2 04/02/2018
UK Region2 05/02/2018
UK Region2 06/02/2018
UK Region2 07/02/2018
US Region1 01/02/2018
US Region1 02/02/2018
US Region1 03/02/2018
Etc


Many thanks

Andy