Problems transferring data to excel in the format that I would like.

[AWA]

The problem I'm having is when I view the data in excel it is listed horizontally (two rows). But I want to send the data into excel as two columns.

What it looks like:
Freq. Level
Row 1 23.4 23.5 23.2
Row 2 75.25 76.25 77.25.


What I want it to look like:

Freq. Level
Row 1 75.25. 23.4.
Row 2 76.25. 23.5
Row 3 77.25 23.2
Row 4 78.25 23.6

I have inclosed the Vi I'm using.



Thanking you in advance for your help 🙂

[Labviewguru]

In the array tools palette, you will find a function that transposes an array. Try this.

If you are saving it to file, you can select this option as an input to the "Save to Spreadsheet File" function.