follow these instructions exactly:
one... add a record id if you don't have one.
transpose - use recordid as a key column.
summarize tool-> group by record id/concat values - add your delimeter here.
create a second branch from your transpose -> create a second summarize tool -> concat name - add your delimieter
off of the name branch create a field called recordID - give it a value 0.
use a union tool.
use a text input tool.
put your new header in it
create a field called recordid - give it a value -1
attache to union tool.
sort by recordid
use select tool - drop recordid.
use output data. no headers. /0 as your your delimiter. NOTE - if you have commas in your data you may have errors. you can fix this by using a formula tool before your value summarize to add quotes around your values.
