Concatenate multiple UPC-numbers to a single cell.

In Gridview Is it possible to create a calculated column with concatenated upc numbers for each of my SKU numbers?

I would like them to be separated in a cell with ", " if possible.

Right now I have 17000 sku's that output to 34000 rows and then have to run a script with the exported .csv in google sheets to concatenate and bring it back down to 17000 rows.

eg.
SKU----------Description------Barcodes
123456------Item123-----------65547899, 65541233, 54432166, 15895475
321654------Item321-----------78945556, 45667789, 14785248, 98778845, 45777456

Thank you in Advance
Adrian

Adrain:

Are you creating the GridView off of the CounterSales UPC code table?

Is your GridView outputting a separate record for each UPC code?

With some better details I could provide a more informed answer.

That's correct Doug. (CounterSales UPC code table)

At the moment I'm outputting 1 row for each UPC which spits out around 34000 rows.
Some of the Item numbers have up to 15 UPC's attached to them, (so they are displayed on 15 rows)
I figure if i could create a new Calculated column that conatenated all of the related UPS for each Item.
Then I could tie each row into my other .CSV export that has 1 row per Item number. (exporting a single CSV instead of two which i combine together in Google Sheets.)

Adrian

Adrian:

Thanks for clarifying how you are using GridView.

What you are currently doing, running GridView to output the data to Google Sheets and then using a script to manipulate the data into what you need, is how I would do this (as an off the top of my head answer).

If I come up with a better answer, I'll let you know.