how to change from column views to row views without losing data

[NY2BOS]

Hello all, 

my data comes in like this

Base	Question	ID
What color	Red	1
What cost	$5.00	1
What color	Blue	2
What cost	$4.00	2

However I want it to look like this for easier usability

ID	What Color	What Cost
1	Red	$5.00
2	Blue	$4.00

the Base and Question columns repeat and are the same for all of the ID values. 

Thank you in advance!

[KerryW · Accepted solution]

You can split the Base questions and rejoin. Work Flow attached

[NY2BOS]

Thank you that solution would work, but i have about 30 other columns. the two columns is an example. 

[KerryW]

You can use a Cross Tab - Updated Workflow atatchedd as well