EDIT: To show data is not just numerical

I would really appreciate some help if possible please! I have some data in a LibreOffice spreadsheet that is structured like this:

```

+----+---------+-------+--+
| ID | Quality | Value |  |
+----+---------+-------+--+
|  1 | Height  |   123 |  |
|  1 | Weight  |   456 |  |
|  1 | Name    |   Jon |  |
+----+---------+-------+--+

```

But I need to transpose the data to show like this:

```

+----+--------+--------+-------+
| ID | Height | Weight | Name  |
+----+--------+--------+-------+
|  1 |    123 |    456 |   Jon |
+----+--------+--------+-------+

```

It's a long file - 85,000 rows, otherwise I'd just do it manually! I have access to LibreOffice, awk, sed, and any other Linux tools. If it came to it I could find a way to use Excel.

Any ideas please? And is transpose the right word?

Many thanks in advance!