Community

Posted: **Wed Sep 30, 2015 9:27 pm**

I have data that looks like this (1000 rows)
'AAA',
'ABA',
'BBB',
'ABB',
'BAA'
etc

I need it to look like this
'AAA','ABA','BBB','ABB','BAA' (Combine every 10 line )
When complete I should have 100 rows

Is this possible?
Steve

Posted: **Thu Oct 01, 2015 7:49 am**

Find what: (.+)\n(.+)\n(.+)\n(.+)\n(.+)\n(.+)\n(.+)\n(.+)\n(.+)\n(.+)
Replace with: $1,$2,$3,$4,$5,$6,$7,$8,$9,$10

[X] Regular expression

Replace All

Community

Combine single field csv into multiple field CSV

Combine single field csv into multiple field CSV