REQ: Help Exporting to Excel

[JCJXXL]

Hello gang!

I've searched for a solution to my question and am unable to come up with anything. Maybe I'm not wording it correct.

When I export to Excel it generates column headers based on what I have labeled my fields.

Is there anyway to make Filemaker export those "headers" to the rows (the left) in Excel rather than the columns?

For my project it makes more sense for the spreadsheet to scroll down than across.

I hope that makes sense.

Thanks in advance for the help.

[Brudderman]

Someone may tell you how to do this in FM itself, but it's pretty easy to handle once you're in Excel. Just select the cells you want to transpose (from Columns to Rows, for example), Copy, and go to Edit > Paste Special > Transpose to paste the transposed cells to wherever you want them.

James

www.james-mc.com

[JCJXXL]

Thank you! I feel like such an idiot. Such a simple little process. It worked exactly as I needed it to.

Thanks again!

[Brudderman]

Don't beat yourself up; this is not one of the obvious or intuitive features in Excel. But I'm glad it helped.

James

www.james-mc.com