I have this data:
product_code,field_type1,field_type1_id,Field_type1_name,field_type2,field_type2_id,Field_type2_name,field_type3,field_type1_id3,Field_type1_name3,field_type4,field_type4_id,Field_type4_name,field_type5,field_type5_id,Field_type5_name,field_type6,field_type6_id,Field_type6_name,field_type7,field_type7_id,Field_type7_name,field_type8,field_type8_id,Field_type8_name,field_type9,field_type9_id,Field_type9_name,field_type10,field_type10_id,Field_type10_name,field_type11,field_type11_id,Field_type11_name,field_type12,field_type12_id,Field_type12_name,field_type13,field_type13_id,Field_type13_name
300413,Marca,28,Brother,2,Tipo,178,Equipo multifuncion,61,Tecnologia impresion,1,Laser,62,Velocidad impresion,4,+ de 30 pag/minuto,63,Tamano impresion,2,Din a4,,,,,,,,,,,,,,,,,,,,
300003,Uso,5,Lapiz,1,Marca,417,Tombow,2,Tipo,218,Goma,,,,,,,,,,,,,,,,,,,,,,,,,,,,
166133,Capacidad,61,1 l,36,Presentacion,6,Tetra brick,1,Marca,373,Alpro,2,Tipo,989,Bebida vegetal,,,,,,,,,,,,,,,,,,,,,,,,
I want this output:
Product_code,Marca_id,Marca_name
300413,28,Brother
300003,417,Tombow
166133,373,Alpor
I have 39 colum, grouped by 3 colum, type,id and name but Marca type can located in any of 13(total 39) fields.
not much idea, if use pivot, melt or need hardcode with loops and other conditional.
