Hello All I got stuck with a request, need to convert the value to be a part of a column, I knew there is a functionality named 'Transpose' which allows user to convert a value into a column. But this time I might need to merge one particular value with some columns in the table. let me give u the example. Here is the original table ID Status Parameter1 Parameter2 Parameter3 10023 AFH2 2.1 50.1 30 10023 AFH1 3.3 78.2 77 And here is the target table I wanted ID Parameter1_AFH2 Parameter2_AFH2 Parameter3_AFH2 Parameter1_AFH1 Parameter2_AFH1 Parameter3_AFH1 10023 2.1 50.1 30 3.3 78.2 77 As you saw, the purse is to exclude the duplicated rows. Does anyone know how to convert the structure like this ? Thanks in advant
... View more