Greetings,
I have a Database that looks like this:
Item1 Component1
Item1 Component2
Item1 Component3
Item2 Component1
Item2 Component2
Item2 Component3
Item3 Component1
Item3 Componnet2
Item3 Component3
etc. etc. etc.
I want to manipulate the data to look like this:
Item1 Component1 Component2 Component3
Item2 Component1 Component2 Component3
Item3 Component1 Component2 Component3
How could I best achieve this?
I have a Database that looks like this:
Item1 Component1
Item1 Component2
Item1 Component3
Item2 Component1
Item2 Component2
Item2 Component3
Item3 Component1
Item3 Componnet2
Item3 Component3
etc. etc. etc.
I want to manipulate the data to look like this:
Item1 Component1 Component2 Component3
Item2 Component1 Component2 Component3
Item3 Component1 Component2 Component3
How could I best achieve this?