View Single Post
  #1   Report Post  
Lua_uk
 
Posts: n/a
Default how do I out all my data into one row

I have data fro a las file which i have opened in excel. due to the number of
columns the las file grouped the data line by line instead of column by
colmn. Due to the amount of data it is impractical to change all the data by
copy & paste:

eg of data what it is like and what I need:

-999.25 -999.25 -999.25 -999.25 -999.25
29.5625 -999.25 -999.25 145.7 51.1411
-999.25 -999.25 51.1411 28.5625 2.4043
1.8379 -999.25 -999.25 -999.25 -999.25
-999.25 -999.25 2.4043 1.8379 -999.25
2.1426 -85.1875

need:

-999.25 -999.25 -999.25 -999.25 -999.25 29.5625 -999.25 -999.25 145.7 51.1411 -999.25 -999.25 51.1411 28.5625

2.4043 1.8379 -999.25 -999.25 -999.25 -999.25 -999.25 -999.25 2.4043 1.8379 -999.25 2.1426 -85.1875