I have a table ( test1 ) with three fields
field1 c (40)
field2 c (40)
field3 c (80)

I have ten records in the table, field3 is empty in all but one record. I want to always display 2 columns in the grid ( field1, field2 ). If field3 is not empty, I need it to display on next grid line under field1, field2 as a single column. Is this possible ?

In order to get needed results now I have created temp table with
tmpField1 c (80)
tmpRecno I

I loop through ( test1 ) row by row and append blank in temp table then replace tmpField1 in the temp table with test1.field1 + test1.field2,tmpRecno with test1 recno()
if test1.field3 is not empty than I append blank to temp table and replace tmpfield1 with test1.field3,tmpRecno with test1 recno(). The grid recordsource is the temp table and displays one column, tmpField1.

I would rather find a way for grid to handle this without building temp table, my real scenerio has many more fields than this example.