Is there a query, or queries that can transform this data ...
Company A 200 2
Company A 400 3
Company A 300 5
Company B 500 1
Company B 500 2
Company C 100 2
Company C 100 4
Into ...
Company A 200 400 300
Company B 500 500
Company C 100 100
Thanks.
RJW
Company A 200 2
Company A 400 3
Company A 300 5
Company B 500 1
Company B 500 2
Company C 100 2
Company C 100 4
Into ...
Company A 200 400 300
Company B 500 500
Company C 100 100
Thanks.
RJW