Required formula to compile the data from raw

[Naveenaggarwal]

Hi,

enclosing herewith a sample sheet with raw data.

I need to figure out some formula to compile the raw data in a matrix table.

In the sheet, A to G col is having data.

in I3, i have data validation to select the process in respect to col G.
As i select I3, i want relevant data to come in their respective place but without repeatance.

i.e.

J2 to S2 models from Col B
J3 to S3 Parts from Col C
I6 to I23 Defects from Col D
J6 to S23 total quantity based on above.

Hope I was clear to explain.

Please support.

Thanks in advance

[FDibbins]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(note: this change is not optional )