Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table that looks like this:
Name | Content | Key |
Firstname | John | 1 |
Lastname | Andersson | 1 |
Age | 30 | 1 |
Firstname | Carl | 2 |
Lastname | Johnsson | 2 |
Age | 40 | 2 |
Firstname | Lisa | 3 |
Lastname | Snow | 3 |
Age | 50 | 3 |
I would like to create a table that looks like this:
Key | Firstname | Lastname | Age |
1 | John | Andersson | 30 |
2 | Carl | Johnsson | 40 |
3 | Lisa | Snow | 50 |
Is there a way to make this in the script while loading this data?
Today the data is loaded like this:
Kind regards, Jonathan