Summary datable with comma separated values in ColumnI 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.
Automation and ScriptingRe: Summary datable with comma separated values in ColumnThere 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.
Re: Summary datable with comma separated values in ColumnThere is also this addin written by me Group Listagg Columns which you might be able to utilize.
