Auto-indexing For Loop: loop output data saved to file is not usable?

[BobJohnsonNI]

I am trying to use auto-indexing with a For Loop to save data (all of the same type) generated in the various incarnations of the loop to a text file (that can be opened in excel). However, the data is organized in the text file/spreadsheet fie is not ordered into just 1 column and however many rows, but 1 row with an excessive amount of columns (one for each point) so that eventually excel won't recognize later data anymore (and the organization of the data is also very inconvenient to work with).

What do I have to do to oder the data in 1 column in consecutive rows?

Would appreciate detailed solution because I am very new to LabView and software can be confusing. I use LabView8.2

Thanks

[RavensFan]

Are you using Write to Spreadsheet File or some other File I/O function?

Wire a true constant to the Transpose? Input of the Write to Spreadsheet file function.

Or if using other File functions, try setting the delimiter to be a carriage return .

[jyang72211]

Try to transpose your array to see does that work.