I have a table Col1 Col2 Col3 Col4 Col5 ----- ------ ------ ----- ------ 1 abc NULL NULL NULL 1 NULL def NULL NULL 1 NULL NULL ghi NULL 1 NULL NULL NULL jkl I want: Col1 Col2 Col3 Col4 Col5 ----- ------ ------ ----- ------ 1 abc def ghi jkl At first I thougt I could use pivot which I'm not sure how...