Login  Register

Re: Transpose Table in Image J help

Posted by Jacob Lewis on Oct 03, 2015; 1:45am
URL: http://imagej.273.s1.nabble.com/Transpose-Table-in-Image-J-help-tp5014534p5014536.html

Hi Michael,

Thanks for your response. I have no programming experience even with macro language. I do need to learn though (that is pretty apparent). I was thinking of using excel but I didn’t think it could handle large data sets.
I have done some googling and I couldn’t find any plugins or macros that would do this.

I will look into seeing if I can figure out the macro you suggested.

Cheers,

Jacob

> On 3 Oct 2015, at 10:02 am, Cammer, Michael <[hidden email]> wrote:
>
> One way to do this would be to write a macro where each column of the results you want would be an array, use ColumnName[index] = getResults("ColumnName", index) and then you use the print command with tabs to reorder the data in rows.  There may already be a macro or plugin for this-- let's see if anyone else responds.
>
> But it might be simpler just to just do this in Excel or some other spreadsheet.  Here are the first three google URLs returned in a search for this:
> https://support.office.com/en-in/article/Switch-transpose-columns-and-rows-ed1215f5-59af-47e6-953b-0b513b094dc2
> https://support.office.com/en-IN/article/Transpose-rotate-data-from-rows-to-columns-or-vice-versa-3419f2e3-beab-4318-aae5-d0f862209744
> http://www.howtogeek.com/howto/15810/convert-a-row-to-a-column-or-backwards-in-google-docs-spreadsheets/
>
>
> _________________________________________
> Michael Cammer, Optical Microscopy Specialist
> http://ocs.med.nyu.edu/microscopy
> http://microscopynotes.com/
> Cell: (914) 309-3270
>
> ________________________________________
> From: ImageJ Interest Group [[hidden email]] on behalf of Jacob Lewis [[hidden email]]
> Sent: Friday, October 02, 2015 7:10 PM
> To: [hidden email]
> Subject: Transpose Table in Image J help
>
> Hi All,
>
> I am using the multi-measure tool in ROI manager, the table format it produces does not work with the plug in written for our group I was wondering if anyone could help with this. I need to transpose the table from default Image J columns to rows.
>
> Any help our advise would be much appreciated.
>
> Cheers,
>
> Jacob
> --
> ImageJ mailing list: http://imagej.nih.gov/ij/list.html
>
> ------------------------------------------------------------
> This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain information that is proprietary, confidential, and exempt from disclosure under applicable law. Any unauthorized review, use, disclosure, or distribution is prohibited. If you have received this email in error please notify the sender by return email and delete the original message. Please note, the recipient should check this email and any attachments for the presence of viruses. The organization accepts no liability for any damage caused by any virus transmitted by this email.
> =================================
>
> --
> ImageJ mailing list: http://imagej.nih.gov/ij/list.html

--
ImageJ mailing list: http://imagej.nih.gov/ij/list.html