The
PIVOT
relational operator explained here
http://msdn.microsoft.com/en-us/library/ms177410(v=sql.90).aspx[
^] can be used for this purpose as shown below:
IF OBJECT_ID('Data','U') is NOT NULL
DROP TABLE Data
CREATE TABLE [dbo].[Data](
[SlNum] [int] NULL,
[Name] [nvarchar](50) NULL,
) ON [PRIMARY]
GO
INSERT INTO Data(SlNum, Name)
VALUES(1, 'Mob1')
INSERT INTO Data(SlNum, Name)
VALUES(2, 'Mob2')
INSERT INTO Data(SlNum, Name)
VALUES(3, 'Mob3')
INSERT INTO Data(SlNum, Name)
VALUES(4, 'Mob4')
INSERT INTO Data(SlNum, Name)
VALUES(5, 'Mob5')
SELECT Mob1, Mob2, Mob3, Mob4, Mob5
FROM
(SELECT SlNum, Name FROM Data) AS SourceTable
PIVOT
(MIN(SlNum) FOR Name IN (Mob1, Mob2, Mob3, Mob4, Mob5)) AS PIVOTTABLE