Changing a data row into multiple data columns

[Anonymous]

Hi guys. I've got a list of people using the following fields

[Account number]

[E-mail address]

[NI number]

If i have a NI number with more than one account, how can i make a table with the following columns:

           NI num    Account number 1    Account number 2    Account number 3

          JJ111111     1234567890           2345678901             3345678901

          JJ346788    1122334455           2223344666             6363636366

Every time i try, it simply says

           NI num    Account number 1    Account number 2    Account number 3

          JJ111111    1234567890            1234567890        1234567890

and repeats the same account number three times.

Can anyone tell me how to split these account numbers?

[Anonymous]

Here's what i've got at the moment, it's fairly simple code

Directory;

LOAD Account,Nationalins,email

FROM

[..\File.DAT]

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

This shows

Ni num	Account num
9191951BB	5195151951951
9191951BB	1959879879879
9191951BB	9819819195195

I'd like it to show

NI num	Account 1	Account 2	Account 3
9191951BB	5195151951951	1959879879879	9819819195195

Can anyone help?