Dear All,
I am facing a problem in Excel that I wish to seek help.
Sheet 1Sheet 2Weekly Sale7 11 StoreBrandQtyBrandQty7 11pespi2Pespi MiniMartpespi14coke easy storecoke 16tea easy storepespi177 11pespi11sheet 3easy storeTea9minimart7 11Tea12BrandQtyMiniMartcoke 13Pespi 7 11coke 10coke easy storepespi8tea MiniMartcoke 4MiniMartpespi57 11Tea3sheet 4MiniMartTea15easy store7 11coke 1BrandQtyeasy storecoke 7Pespi MiniMartTea6coke easy storeTea18tea
Any useful format to use to get the Qty from each drink base on each store??
Please find attachment and give comment / advice
I am facing a problem in Excel that I wish to seek help.
Sheet 1Sheet 2Weekly Sale7 11 StoreBrandQtyBrandQty7 11pespi2Pespi MiniMartpespi14coke easy storecoke 16tea easy storepespi177 11pespi11sheet 3easy storeTea9minimart7 11Tea12BrandQtyMiniMartcoke 13Pespi 7 11coke 10coke easy storepespi8tea MiniMartcoke 4MiniMartpespi57 11Tea3sheet 4MiniMartTea15easy store7 11coke 1BrandQtyeasy storecoke 7Pespi MiniMartTea6coke easy storeTea18tea
Any useful format to use to get the Qty from each drink base on each store??
Please find attachment and give comment / advice