Aha, pro Eintrag in Feld1...Feld5 eine Zeile im Resultat.
SQL-Code:
select * from tabelle where feld1 is not null
union
select * from tabelle where feld2 is not null
union
select * from tabelle where feld3 is not null
union
select * from tabelle where feld4 is not null
union
select * from tabelle where feld5 is not null
order by coalesce (feld1,feld2,feld3,feld4,feld5)