Jesu
12-31-2015, 03:13 AM
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
-
-
-
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
-
-
-