topic Re: Summary datable with comma separated values in Column in Discussions

Summary datable with comma separated values in Column

pankajsync — Tue, 23 Jul 2024 17:05:24 GMT

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.

Re: Summary datable with comma separated values in Column

jthi — Tue, 23 Jul 2024 17:15:57 GMT

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

remember to kudo this so Summary could do this.

Re: Summary datable with comma separated values in Column

jthi — Tue, 23 Jul 2024 17:24:12 GMT

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