Hello,
Here is my data! Basically everything is in the same table, however I separated to better explain my problem!
|
number
|
customer
|
ref
|
|
1
|
1
|
A
|
|
2
|
1
|
B
|
|
3
|
1
|
C
|
|
4
|
2
|
D
|
|
number
|
customer
|
ref
|
|
2-1
|
X
|
B
|
|
2-2
|
X
|
B
|
|
3-1
|
X
|
C
|
I would like a table that groups all the data as you can see here, with an order as you can see made by a correlation on the "ref" :
|
number
|
customer
|
ref
|
|
1
|
1
|
A
|
|
2
|
1
|
B
|
|
2-1
|
X
|
B
|
|
2-2
|
X
|
B
|
|
3
|
1
|
C
|
|
3-1
|
X
|
C
|
|
4
|
2
|
D
|
I have already tried many things, the map, the append, the foreach, etc.
Do you have any ideas?
Thank you
