Changing how data is oriented

[NY2BOS]

Hello all my data come in like this 

Variable	Variable Name	ID
Color	Blue	1
Size	Large	1
Price	$5.00	1
Color	Red	2
Size	Small	2
Price	$4.00	2

However I want the data to look like this

ID	Color	Size	Price
1	Blue	Large	$5.00
2	Red	Small	$4.00

this is an example of how the data comes in there are actually 16 columns with data. 

Thank you for all your help in advance.

[PHinkel]

Hi @NY2BOS , you will want to use the Cross-Tab tool with the following settings: