Data consolidation

I am very new to AETL. I have a table that has three fields in it, Code, LineNo, and Address. Here are the sample data:
Code LineNo Address
A 1 Address 1
A 2 Address 2
B 1 Address 1
B 2 Address 2
B 3 Address 3
C 1 Address 1
D 1 Address 1
D 2 Address 2
D 3 Address 3
D 4 Address 4
ETC

I want to consolidate this table so that each record is corresponding to a specific Address. The new table will only have two fields, Code and Address. The data should look like this:
Code Address
A Address 1; Address 2
B Address 1; Address 2; Address 3
C Address 1
D Address 1; Address 2; Address 3; Address 4

Can I do this using AETL?

Thanks,
Frank

Everything is possible it is all depends how much you want it

You can do it by using keep value function + calculation
But it is rather complicated example
Or you can use pivot transformation

Watch this online tutorial you will get an idea

www.dbsoftlab.com/online-tutorials/advan...ivot-and-sorter.html

Peter