|----------|

| 3

|----------|

|

|----------|

|

|----------|

Ok.. When I export my database from FM Pro to an Excel file, everything is grouped exactly how I want it. The only problem I'm having is with blank columns. As you can see above, I'm getting blank columns under the parent cell. I was expecting the 3 to be repeated in the cells underneath. This is happening to all the cells in the excel file. Rather than Excel assume that the cells underneath are the same as the parent, (which they are), I would like the blank cells to repeat the parent cell.. Any ideas?

[color:orange]HERE'S a link to a diagram of the problem.

Edited March 29, 200718 yr by Guest

[color:green]PROBLEM SOLVED

I just exported the file differently from Filemaker: I first exported the database as a html table and then copied the table into excel - no more blank cells.