Summary datable with comma separated values in Column

[#1]

I would like to make a summary of table in SHEET1 and include Wafers in it. My desired output column is in SHEET2. I wanted to develop a script which can give me output like SHEET2. Note SHEET2 is summary of SHEET1. In Sheet2, I wanted wafers to be separated by comma. The wafers should be num(right(Wafers,2)) in the SHEET2.

[#2]

There are quite a few posts about something similar like this. I would suggest using Query function with GROUP_CONCAT,  Similar keys (for some reason the original post has been deleted so that post can be a bit difficult to utilize).

Add Listagg/Concatenate/GROUP_CONCAT to Summary platform remember to kudo this so Summary could do this.

[#3]

There is also this addin written by me Group Listagg Columns which you might be able to utilize.