LabView/excel question. How do I place my headers in columns properly?

[GRCK5000]

I want my headers to be placed in columns as shown below:

This is what I get instead. I wish I could transpose it like in matlab.

I have attached my code

[GRCK5000]

Never mind guys. I found the solution! Hoorayyyyyy!!!! kudo to myself . 🤗

[avogadro5]

The "Write to Text File" node writes an array one element per row, you want the spreadsheet VI, if you give it a 1d array it writes it as a single row with delimiters (tabs by default) between the elements.

[altenbach]

Ah, what a mess:

• You output file has absolutely nothing to do with Excel . It's just a tab delimited text file that excel can open if done right.
• Why are front panel and diagram windows so oversized?
• You probably don't want to run the remaining code if the file dialog has been canceled. (see picture)
• Why all these explicit file operations of you already have a suitable tool? (see picture)
• There is an "=0?" primitive. Even simpler, just wire the integer to the case selector and make one case zero and the other "default".
• Why do you have two 1000ms waits running in parallel (TRUE case). Makes no sense. Both will finish at the same time.
• There seems to be no valid way to stop the VI (the abort button is NOT a valid way!).
• For array diagram constants, I recommend to always show one element more than the size (or show the scrollbar). else the programmer needs to guess if there are hidden elements. (container size != array size!)
• ...