creating list based on several criteria on another sheet

[gdmpat]

Dear Sir(s) or Ma'am,

I would greatly appreciate any help rendered for issue that I've been dealing with for several days,

what I would like to achieve is that a combined information on separate worksheet that "LOOKUP" the OCode so that it would stack up nicely without any blanks in the rows

I put the raw data table in "B4 raw data" sheet

what I've done so far is pivoted the raw data sheet and copy-paste'ing the information manually, as the "name" value currently is assigned to the raw data by a simple VLOOKUP based on the "Ocode"

would it be possible to generate the combined list in sheet "b4 result" in cell a7:a100 automatically based on the value in d1.
d1 would refer to column AG in the "B4 raw data" sheet (similar to pivoting but by formula)

could anyone be so kind to assist in showing the way?

may gratitude in advance to the guru's of excel :D

[Anka]

Hi gdmpat

Sorry for the delayed response to your message, but I was a little busy. If you're still interested, I have a solution. I had to change a bit.
What is Sale M-1? Monthly sales?
The sheet is not complete but is easily to continue (to put the formulas).

See if is what you want, and give us the news.