Transpose to a single cell starting with ' and separated by ,

Question

Hello,

Probably a basic question but i am very lost. I have a list as follows

Order #s

12345

23456

67891

The number of these rows (=orders is variable, 3 as an example here). i want to have the following results

'12345','23456','67891'

Thanks in advance guiding me in the right direction

AshleyL · Accepted Answer

Hey @Saadshj

Going off of @Aaron_Harter -- if you want quotes around each order number, I would use a formula tool instead of a Select tool with the formula: "'" + ToString([Order#]) + "'" to create a new column to use in the summarize tool!

Aaron_Harter · Accepted Answer

@Saadshj - updating the Separator condition to include the extra quote between each item: