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 -- Mark Lawrence