Sql server Row To Columns Data : I have data in a SQL Table with the following structure:
Engine_No Date  Process Bolt_No1 B1Value1 B1Value2 B1Value3 Bolt_No2 B2Value1 B2Value2 B2Value3  Bolt_No3 B3Value1 B3Value2 B3Value3 Bolt_No4 B4Value1 B4Value2 B4Value3

I want to display the following results of a query:

Engine_No Date  Process  Bolt_No1   B1Value1  B1Value2  B1Value3  
Engine_No Date  Process  Bolt_No2   B2Value1  B2Value2  B2Value3        
Engine_No Date  Process  Bolt_No3   B3Value1  B3Value2  B3Value3  
Engine_No Date  Process  Bolt_No4   B4Value1  B4Value2  B4Value3

Can someone suggest a auery that achieves this?