Formula so as to Add Multply values in cell using a vlookup formula

[NZAS]

I have a data set that I want to be able to return multiple values for this to the same cell. The data set has a list of pours that are stored in BINS. I want to be able to return using a vlookup or similar to populate those pours into the relevant cell in the matrix like below the data. I would only return 1 of each if there are multply pour values in the data set.
The data set can cover many pours and many Bin allocations. I hope there is way to be able to do this even if it not a vlookup as I though I would use. Currenlty I can only get 1 pour value.
Cheers
NZAS

POUR	RUN_COUNT	PRODUCT	ALLOY	WEIGHT	BINAREA	BIN
11823	9	3A949	AA190J	1023	STD1A	AC408		This data set has a lot of data listed of all POURS that are stored in Bins. I need a formula that will return list of the Pour values that are in the same Bin Number as shown below. I have a formula that I have used but only returns one of the pour numbers. This data is downloaded from a data base to excel. This gives a more visual view of where pours are stored
11823	4	3A949	AA190J	1023	STD1A	AC408
11846	1	3A949	AA190J	1023	STD1A	AC408
11823	3	3A949	AA190J	1024	STD1A	AC408
11823	8	3A949	AA190J	1025	STD1A	AC408
11823	6	3A949	AA190J	1027	STD1A	AC408
11823	11	3A949	AA190J	1027	STD1A	AC401
11823	2	3A949	AA190J	1027	STD1A	AC408
11823	14	3A949	AA190J	1027	STD1A	AC408
11823	5	3A949	AA190J	1027	STD1A	AC408		For the purpose of this the data displayed I have just 1 bin number with numerous pour values
11821	30	3A949	AA190J	1028	STD1A	AC408
11823	7	3A949	AA190J	1028	STD1A	AG404
11823	13	3A949	AA190J	1028	STD1A	AC408		Conditional Formatting criteria is used to hilight the cells that store the pours
Output for Casts
STD1A	401	402	403	404	405	406	407	408	409	410	411
AA
AB
AC	11823							11823 11846 11821
AD				11829
AE
AF		11881
AG				11823
AH

<tbody>
</tbody>

POUR	RUN_COUNT	PRODUCT	ALLOY	WEIGHT	BINAREA	BIN
11823	9	3A949	AA190J	1023	STD1A	AC408		This data set has a lot of data listed of all POURS that are stored in Bins. I need a formula that will return list of the Pour values that are in the same Bin Number as shown below.The dataset is downloaded from a data base to excel is updated. the matix below gives a more visual view of where pours are stored
11823	4	3A949	AA190J	1023	STD1A	AC408
11846	1	3A949	AA190J	1023	STD1A	AC408
11823	3	3A949	AA190J	1024	STD1A	AC408
11823	8	3A949	AA190J	1025	STD1A	AC408
11823	6	3A949	AA190J	1027	STD1A	AC408
11823	11	3A949	AA190J	1027	STD1A	AC401
11823	2	3A949	AA190J	1027	STD1A	AC408
11823	14	3A949	AA190J	1027	STD1A	AC408
11823	5	3A949	AA190J	1027	STD1A	AC408		For the purpose of this the data displayed I have just 1 bin number with numerous pour values
11821	30	3A949	AA190J	1028	STD1A	AC408
11823	7	3A949	AA190J	1028	STD1A	AG404
11823	13	3A949	AA190J	1028	STD1A	AC408		Conditional Formatting criteria is used to hilight the cells that store the pours
Output for Casts
STD1A	401	402	403	404	405	406	407	408	409	410	411
AA
AB
AC	11823							11823 11846 11821
AD				11829
AE
AF		11881
AG				11823
AH

<tbody>
</tbody>

 

[Legacy 143009]

In such scenario

POUR	RUN_COUNT	PRODUCT	ALLOY	WEIGHT	BINAREA	BIN		STD1A	401	402	403	404	405	406	407	408	409	410	411
11823	9	3A949	AA190J	1023	STD1A	AC408		AA
11823	4	3A949	AA190J	1023	STD1A	AC408		AB
11846	1	3A949	AA190J	1023	STD1A	AC408		AC	11823							11823 11823 11846 11823 11823 11823 11823 11823 11823 11821 11823
11823	3	3A949	AA190J	1024	STD1A	AC408		AD				11829
11823	8	3A949	AA190J	1025	STD1A	AC408		AE
11823	6	3A949	AA190J	1027	STD1A	AC408		AF		11881
11823	11	3A949	AA190J	1027	STD1A	AC401		AG				11823
11823	2	3A949	AA190J	1027	STD1A	AC408		AH
11823	14	3A949	AA190J	1027	STD1A	AC408
11823	5	3A949	AA190J	1027	STD1A	AC408
11821	30	3A949	AA190J	1028	STD1A	AC408
11823	7	3A949	AA190J	1028	STD1A	AG404
11823	13	3A949	AA190J	1028	STD1A	AC408
																			:

<colgroup><col span="16"><col><col span="3"></colgroup><tbody>
</tbody>

{=IF(NOT($G1:$G14=$I4&Q$1),TEXTJOIN(" ",1,(EXACT($G1:$G14,$I4&Q$1),$A1:$A14,"")),"")}
Use this array fomula in Q4. It's an array formula so Ctrl+Shift+Enter after paste.