How do i split the column into different columns in SQL Server

[phanikumar32]

Hi all,

Can any one please provide me the SQL Query for getting my required Output.

I have a table in my sqlserver.That table stores the values like shown in the Figure 1.

From that Input i want the Output as Shown in Figure 2.

Please provide me the SQL Query to get that Output

Thanks In Advance,
Phani Kumar