Fast CSV columns sorting
Fast CSV columns sorting
(OP)
I'd like to know if exist a simple program that can sort columns of a .csv (actually semicolon separated value) without need to make it manually.
I need this because the program that make me the report use the columns in a wrong order and everyday I have to sort them manually in excel. It is quite boring and shouldn't hard to automatize.
Thanks
I need this because the program that make me the report use the columns in a wrong order and everyday I have to sort them manually in excel. It is quite boring and shouldn't hard to automatize.
Thanks





RE: Fast CSV columns sorting
RE: Fast CSV columns sorting
although i've not accomplished this technique, try this...
1) copy the data and USING the paste special command, select values and the TRANSPOSE option. select OK. this action transposes the data (i.e. row data are now column data and vice versa).
2) then use the standard excel sort criteria to sort data to your desire.
3) repeat step 1) and check. you might need to experiment a couple of times to obtain the desired sort.
Good luck!
-pmover
RE: Fast CSV columns sorting
RE: Fast CSV columns sorting
TTFN
RE: Fast CSV columns sorting
Also pmover's one seems good... I'll try them both....
RE: Fast CSV columns sorting
TTFN
RE: Fast CSV columns sorting
I'll try to make a macro that add a new row write in it the numbers, sorts colunms and delete the row.
Eng tips ROCKS!