Hi there.
I have a table which contain 3 columns: ID, Name and Value
The ID is not a PK and can repeat, the name will remain constant for each ID, but the value will vary but always relate back to the specific ID.
I need to get this from the current long table format into a wide table with...