Simply use a UNION
SELECT [Person] as [Perdson],[Billing Street] as [Street], [Billing City] as [City] FROM Tbl
UNION
SELECT [Person],[Home Street] [Home City] from tbl
Simply use a UNION
SELECT [Person] as [Perdson],[Billing Street] as [Street], [Billing City] as [City] FROM Tbl
UNION
SELECT [Person],[Home Street] [Home City] from tbl