How can i convert this rows :

```
id id_name flag tag_name tag_type tag_value
1   1       163   XO       c          10
1   1       163   X1       c           0
1   1       163   AM       c           5

```

to this one row :

```
1   1      163      XO:c:10 X1:c:0 AM:c:5

```

Without using pivot ??