M
mcnews
my table looks like
id type1 type2 type3
xxx1 t1 t2
xxx2 t2
xxx3 t3
xxx4 t1 t3
xxx5 t1
xxx6 t2
i need it to look like
id type
xxx1 t1
xxx4 t1
xxx5 t1
xxx1 t2
xxx2 t2
xxx6 t2
xxx3 t3
xxx4 t3
changing the table structure is not an option
tia,
mcnewsxp
id type1 type2 type3
xxx1 t1 t2
xxx2 t2
xxx3 t3
xxx4 t1 t3
xxx5 t1
xxx6 t2
i need it to look like
id type
xxx1 t1
xxx4 t1
xxx5 t1
xxx1 t2
xxx2 t2
xxx6 t2
xxx3 t3
xxx4 t3
changing the table structure is not an option
tia,
mcnewsxp