Hello Everyone,
I'm having an issue where I can't even seem to find the right key words to search on.
I have data in a query that I've giving up on rewriting to split into columns, so I was hoping to see if anyone had some ideas on how to move the data into rows?
Here is a crude example of what I have
<tbody>
</tbody>
And what I am hoping for
<tbody>
</tbody>Any ideas?
I'm having an issue where I can't even seem to find the right key words to search on.
I have data in a query that I've giving up on rewriting to split into columns, so I was hoping to see if anyone had some ideas on how to move the data into rows?
Here is a crude example of what I have
Car_No | wheel | tire | |||
100 | 17 | BFG | |||
100 | 16 | Goodyear | |||
100 | 15 | BFG | |||
101 | 17 |
<tbody>
</tbody>
And what I am hoping for
Car_no | Wheel | Wheel_2 | Wheel_3 | Tire_1 | Tire_2 | Tire_3 | |||
100 | 17 | 16 | 15 | BFG | Goodyear | BFG | |||
101 | 17 | ||||||||
<tbody>
</tbody>