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

[Saadshj]

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

[Aaron_Harter]

Hi @Saadshj, 

Check out the Concatenate function of the Summarize tool:

 

[AshleyL · Accepted solution]

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 solution]

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

 

[Saadshj]

Brilliant, works perfectly. thank you guys, very much appreciated