Need help to compile data

Dear Expert,

Please help for compile attached data in below format -

from compile data sheet i just compile 2 store locations data so same i want to compile data for all store so please help -

Brands Month-Year Qty Value Store Code Store Locations

Thanks
Imran

Please try and clarify what you are trying to accomplish.

Dear Sir,

Attached data is store wise so when i am gong to compile this data i have to compile this data manually like copy & paste.

so help to create one macro then we can compile this data through macro.

for example i just compile 2 store data in raw data sheet.

regards
imran

Dear Sir,

Thank u so much,data is compile but output Qty & Value is not correct compile so please check & suggest whats we have to do.


Regards
Imran

Thank u sooo much Sir,now getting correct data.