Help with Export One to Many into Excel with unique columns

[Michael Stevens]

I have a parent table with 3 child tables.  In the child table, there can be many related fields.  I need to export only one row of data for each record in the parent table.  This would require that a new column be created for each of the many values related in the parent to the child.

For Instance:

Noah Justin has 3 Email Address [email protected], [email protected], and [email protected]

When I do an Excel Export from FM I get

Column 1 .       Column 2
Noah Justin    [email protected]
                          [email protected]
                          [email protected]

I need:
Column 1 .     Column 2 .        Column 3 .          Column 4
Noah Justin  [email protected]  [email protected]  [email protected]

I'm sure it's pretty common and there is an easy solution to this.  

TIA

[comment]

6 hours ago, Michael Stevens said:

I'm sure it's pretty common and there is an easy solution to this.  

I don't think it's very common and I don't know of an easy solution to this. Filemaker will export records as rows, not columns. If you must have columns AND must have an Excel .xlsx file as the result, you would need to add a calculation field for every potential e-mail address a parent record might have.

Possible workarounds:

1. Build your own export in a global text field and export this; the result will be a .csv file that can be read by Excel;
2. Export as XML and use a custom XSLT stylesheet to transform this into a file in Excel 2003 XML format;
3.  Use a plugin? (I am afraid I don't know much about this option).

--
P.S. Please update your profile to reflect your version and OS.