I would like to know if it is possible to transform multiple records into a single line.
Explaining, I have the following Select:
pedido - etiqueta - campo - valor
1 - 1 - A - 99
1 - 1 - B - 88
1 - 1 - C - 77
1 - 2 - A - 12
1 - 2 - B - 23
1 - 2 - C - 34
Detail: In some cases (depending on the label), the number of information (A, B, C) may vary, not in the same request (in the same request the structure will be The same), but so the solution would have to be generic to meet all situations.
grateful,