Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
How do I take the first field values and convert them to distinct field names
Example if I have this table
| name | values |
|---|---|
| sweden | 3 |
| sweden | 2 |
| denmark | 3 |
| germany | 8 |
| usa | 5 |
| usa | 5 |
| usa | 6 |
Then I want it to bee like this
| sweden | denmark | germany | usa |
|---|---|---|---|
| 3 | 3 | 8 | 5 |
| 2 | 5 | ||
| 6 |
Is this possible?
Thanks! Generic Load was what I was looking for