Copy multiple columns and paste into one column, based on row criteria

Hi,
I am newbie in VBA, but know excel formulas in advance level.. So I will appreciate any help and supported provided..
I have searched the forums for what I need but nothing was matching

So,
I have an excel sheet with several rows and columns.
In each row there are City name & Dates and in each columns have sales by different Units (A1, A2, A3 etc..)

Please find below raw data:
on3ZP0W.jpg

What I want to see is :
jB8wdEN.jpg

Also you can download workbook from following link: https://app.box.com/s/kj3fixsl13cfikhgt15p7fr63ogzdnvs
There is two sheet - Raw Data & What I want to see


Thank you in advance!!!!

use can use this code with a new sheet name Data

Please Login or Register  to view this content.

Here is your excel sheet, run the macro and u will get the result.

Thank you for genial solution!!!

Thank you all guys!