Exporting measurements to single line in excel

tgagne · June 2016

Is there away to get the measurements to get exported to a single line in excel. The tall format does not work well for any post-hoc analysis in r etc, and it requires a lot of tedious work to transpose each image entry.

I have a number of features with distances in between.

YuriG · June 2016

Please check this topic : http://forums.mediacy.com/discussion/10/how-to-access-measurement-data-in-your-app/p1. It shows a macro to print measurement values to Output window, you can change it to print all in one line. The text from the Output window can be sent to Excel or saved to file.

Yuri

tgagne · June 2016

Thank you for the help, but I could use a bit more guidance.

How do a create a macro? And how would I go about creating a macro that will print all measurements on a single line entry?

Thank you so much for the help!

YuriG · June 2016

Another option, if you prefer working with Excel, it to transpose table in Excel (http://forums.mediacy.com/discussion/10/how-to-access-measurement-data-in-your-app/p1 ), so you turn Columns to Rows and all your data will be in one line.

Yuri

Exporting measurements to single line in excel

Answers