Inserting data in a tall format

Sure, he had a table that looked like this

,,,1,2,3,,,,2010-01-01 00:00:00
4,5,6,,,,,,,2010-01-01 00:00:00
,,,,,,7,8,9,2010-01-01 00:00:00

and he wanted to combine those rows into one like this

4,5,6,1,2,3,7,8,9,2010-01-01 00:00:00

We’re doing it w/ a temp table right now, but you can see where the idea of doing an insert select from the same table would have been cool :slight_smile: