Excel: Display all values of the same date vertically


Hi everyone, I need some help so badly! Here's a sample of the project I am working on with. Sheet 1 ----------------------------------------------------------------------

DATE DEALER PICKUP SITE PRODUCT QUANTITY
1-Apr-14 ACAPARROS EX-PASIG L.LAPU 300
2-Apr-14 CALOSUY EX-PASIG L.LAPU 200
3-Apr-14 AMSERCO FOB MILL ELEF. 500
12-Apr-14 ASIATIC EX-PASIG L.LAPU 700
16-Apr-14 ACAPARROS EX-PASIG ELEF. 1500
1-May-14 ASMART EX-PASIG ELEF. 1500
2-May-14 ASMKTG EX-PASIG G.HARV. 1500
3-May-14 CALOSUY EX-PASIG S.BLEND 300
4-May-14 AMSERCO FOB MILL L.LAPU 200
5-May-14 AMSERCO FOB MILL L.LAPU 500
5-May-14 AMSERCO FOB MILL L.LAPU 700
5-May-14 AMSERCO FOB MILL G.HARV. 1500
5-May-14 CALOSUY FOB MILL S.LORD 500
13-May-14 AMSERCO FOB MILL ELEF. 300
20-May-14 AMSERCO FOB MILL L.LAPU 300
Sheet 2 ----------------------------------------------------------------------------
MONTH: APRIL DAY: SITE: EX-PASIG
DEALER DATE L.LAPU ELEF. ORO EX. G.HARV. S.LORD S.BLEND A.PURP. S.NOODLE S.GODD. C.TAIL E.DRAGON
Here's what I wanted to happen. Month, Day and Site have their corresponding data validation list where you can pull up the records to display under the table above once criteria are met and automatically add the values of the same products of the same date. Example: I will select from the list the ff in the search criteria: Month: May Day: 5 Site: FOB MILL It should display like this:
DEALER DATE L.LAPU ELEF. ORO EX. G.HARV. S.LORD S.BLEND A.PURP. S.NOODLE S.GODD. C.TAIL E.DRAGON
AMSERCO 5-May-14 1200 1500 CALOSUY 5-May-14 500 Please help. Thank you!


This question generated 42 answers. To proceed to the answers, click here.

This thread is current as of May 20, 2014.


For more resources for Microsoft Excel