| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
| Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
| Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Threaded Mode
