In a table: How to convert rows into columns and vice versa?

Share icon

Wed, 10/31/2012 - 05:40 am

That's all.
Thanks for answering.
ModifyTable Elements Command Help file:
Quote:
As you look down in the table, you see the rows of the matrix and as you look across the table, you see its columns. Thus, initially, the rows dimension is mapped to the vertical table dimension in the and the columns dimension is mapped to the horizontal table dimension. This is the default mapping. You can change this with the following command:
ModifyTable elements(wave0) = (-3, -2)
The first parameter tells Igor how you want to view the wave's rows and the second parameter tells Igor how you want to view the wave's columns. Since the wave has only two dimensions, the third and fourth parameters can be omitted.
The -3 in this example tells Igor that you want to map the wave's rows to the table's horizontal dimension. The -2 tells Igor that you want to map the wave's columns to the table's vertical dimension.
You can return the wave to its default view using:
ModifyTable elements(wave0) = (-2, -3)

October 31, 2012 at 07:08 am - Permalink

If you want to transpose the data rather than just the visual orientation in the table . . .

If your data is 2D, use the MatrixTranspose operation from the command line.

If your data is 1D, choose Help->WM Procedures Index. Then choose Edit->Find and search for "transpose" (without the quote). You will find the "Transpose Waves in Table" procedure. Click the "load" button (the one without the X through it). This will open the procedure file. Read the comments for instructions.

October 31, 2012 at 08:01 am - Permalink

Thank you very much.
Unfortunately I was not able to follow your recommendations. In the index list I found the following:

#include
Contains the WMTransposeTableMenu and WMTransposeWavesInTable procedures, and adds a "Transpose Waves In Top Table" item to the Table menu. These combine to make new waves that are the transpose of the waves in the top Igor table, optionally displayed in a new table. For example, if you have a table with 3 waves each containing 10 rows, you'll end up with 10 new waves, each with 3 rows.

This is exactly what I need. However, when I copy-paste the #include line into the Procedure window I get the reply that the include file was not found. In the WM procedures folder also I could not obtain a procedure with this or a similar name.

I work with Igor 5.0.1.0.

Thanks again.

November 25, 2012 at 04:35 am - Permalink

Synapse wrote:
However, when I copy-paste the #include line into the Procedure window I get the reply that the include file was not found. In the WM procedures folder also I could not obtain a procedure with this or a similar name.
I work with Igor 5.0.1.0.


It's possible that your Igor Pro installation is messed up.

Pasting this into the procedure window works for me in Igor Pro 5.03:
#include <Transpose Waves In Table>


I don't have 5.01 to try.

You can get a free update to 5.05 here: http://www.wavemetrics.net/updaters50.html

You can update to the latest version, 6.30B01, here: http://www.wavemetrics.net/Updaters/AboutPublicBetaVersions.html. That will get you a 30-day fully-functional trial. After that time you will need to purchase an upgrade.

November 25, 2012 at 11:02 am - Permalink