I have output from one program that has my data in sets of 6 columns and 20 rows per datapoint (person) I need the 20 rows (in 6 cell sets) to fit into one long row.
Use Notepad++ and its RegEx feature to remove line breaks to get a single date row.
- Save the Excel file as .CSV and open it with Notepad++
Replace the newline character
\r\n
with your corresponding delimiter;
or,