Here is my situation.
I have a table with 3 columns
The first column is a link column the second column is called name and the third is called data.
The column called name include different name like name, description, type and so on.
The data is the result of these column.
For instance if the name was called 'Date', data would represent the actual date.
if the data column would say 'description' the data column would show the description.
Here is an example.
ID NAME DATA
1 Date 1/1/2012
1 Description Manual
1 Type book
1 Quantity 5
So what I am looking for is a result as follow.
ID DATE DESCRIPTION TYPE QUANTITY
1 1/1/2012 Manual Book 5
Has you can see above, the value in the columns become a single row instead of having 3 columns and have multiple time the same ID, I get 5 column for one single id value.
Any help would be appreciate.
I have tried different options and none of them work.