Vertical list to horizontal csv loop 500

[joesparty]

Hello,

I have a list of 20k email addresses.  The goal is to convert the list to a csv, but limit each file by 500 records.  I'm sure I need a cross tab, but stuck on how to create the csv:

START

email

user1@domain.com
user2@domain.com
user3@domain.com 

END

user1@domain.com,user2@domain.com,user3@domain.com (file 1.csv)

user501@domain.com,user502@domain.com,user503@domain.com  (file 2.csv)

[FinnCharlton · Accepted solution]

Hi @joesparty , here's how to write one csv per 500 records:

We use a record ID to number the records, then calculate a file name based on that number. Each file name will be attached to 500 records. We can then use the 'Take File Name from Field' option in the Output tool to write each set of 500 records into a separate file. Hope this helps!

[joesparty]

That does help with the 500 rows.  Any suggestions on how to concatenate the names before writting to csv?

[joesparty]

The summarize, not cross tab, was the tool to use.