A simple question or not...

[Jesu]

Hi all

My name is Jesus and I am triying to do something like this, I tried do it by SQL and I could not do it and I suppose that I would be able to do by VBA but before I would like to know if I am ringht or not, maybe there is a simple way known by everybody to do it or not. thanks in advance.

Origin table;



ID Number
Provider
Work name
Quantity


1
A
Z
1


2
A
Z
1


1
B
Z
1


1
B
Y
2


2
B
Y
2






Target table:




ID Number
Provider_1
Work name_1
Quantity_1
Provider_2
Work name_2
Quantity_2
Provider_3
Work name_3
Quantity_3


1
A
Z
1
B
Z
1
B
Y
2


2
A
Z
1
B
Y
2
-
-
-