I have the following table:
| Attribute1 | Attribute2 | Attribute3 | Attribute4 |
|---|---|---|---|
| a | valueX | valueY | valueZ |
| b | value1 | value9 | value7 |
| c | value8 | valueH | valueG |
| d | valueQ | value3 | value0 |
I need to transpose and transform this table in R like this:
| Attribute1 | Attributes | Value |
|---|---|---|
| a | Attribute2 | valueX |
| a | Attribute3 | valueY |
| a | Attribute4 | valueZ |
| b | Attribute2 | value1 |
| b | Attribute3 | value9 |
| b | Attribute4 | value7 |
| c | Attribute2 | value8 |
| c | Attribute3 | valueH |
| c | Attribute4 | valueG |
I tried so far to use the t() function, but without a good result.
I mention that I have multiple number of attributes.
Can you please give me a clue?