On 02/17/2016 03:22 PM, nomad at null.net wrote: > On Wed Feb 17, 2016 at 06:17:40PM +0000, David Bicking wrote: >> I have a table >> I L V1 1 A1 2 A1 3 A1 4 B1 5 B1 6 A1 7 A2 1 C2 2 C > The formatting of this (and your desired results) does not make the > question clear enough. Can you resend with each row on a separate line > and perhaps the text "NULL" to represent empty values? > > Mark
Each row was on a separate line. Why it got squished on to one line is beyond me. Nor do I know how to make it not be squished. But thanks for looking anyway. David