 <p>Perhaps:</p> <pre><code>select a.name, a.uniqueCustID, a.info1, b.info2, c.info3 from table1 a left outer join table1 b on b.pk = a.pk and b.info1 is not null left outer join table1 c on c.pk = a.pk and c.info2 is not null </code></pre> <p>The left outer joins are needed because you don't know in advance if a user will have 1, 2 or 3 records with data. This way, if there is no data, a null will be inserted in the corresponding field.</p>