Hi,
Anyone could help me to roll up the data when there's only one key of ID and distribute to many (One to many)
One ID no. has only one title, but has many CCC, R, C,T as below table
The data I extract from the server becomes like this
<tbody>
ID no
Title
CCC
R
C
T
SAQ1234
AAA
H22
0.51...