Thread: moving rows
View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
what delimiter is used in the *.csv file and what is set in your Windows
registry?

Some workarounds:
- use 'Data - Text to columns' to separate the data
- rename the *.csv file to *.txt as then the textimport wizard is started
and you can specify the delimiter

--
Regards
Frank Kabel
Frankfurt, Germany
"cdshon" schrieb im Newsbeitrag
...
I have a large report in tab or csv format that creates 3 rows of data in
Excel that I want to move to a single row. Cut and paste will take
forever.
What can I do?