Hi guys,
I have the following table
NINo - AccNo - Saving
AAAA - 1234567890 - 10
AAAA - 2222222220 - 50
AAAA - 4554545454 - 60
CCCCCC - 4981451191 - 10
DDDDDD - 9841918951 - 55
AAAA - 9878978979 - 10
DDDDDD - 6541651511 - 10
I need to merge it (see template attached) so ideally i'd need to take the above table and format it as follows
NINo - acc 1 - saving 1 - acc 2 - saving 2 - acc 3 - saving 3 - acc 4 - saving 4
Can anyone suggest a solution? Database and merge document attached
I have the following table
NINo - AccNo - Saving
AAAA - 1234567890 - 10
AAAA - 2222222220 - 50
AAAA - 4554545454 - 60
CCCCCC - 4981451191 - 10
DDDDDD - 9841918951 - 55
AAAA - 9878978979 - 10
DDDDDD - 6541651511 - 10
I need to merge it (see template attached) so ideally i'd need to take the above table and format it as follows
NINo - acc 1 - saving 1 - acc 2 - saving 2 - acc 3 - saving 3 - acc 4 - saving 4
Can anyone suggest a solution? Database and merge document attached