October 18, 200619 yr 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.
October 18, 200619 yr 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
October 19, 200619 yr Author Thank you! I feel like such an idiot. Such a simple little process. It worked exactly as I needed it to. Thanks again!
October 19, 200619 yr 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
Create an account or sign in to comment