Changing a data row into multiple data columns

Anonymous — Fri, 01 Feb 2013 15:08:25 GMT

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?

Re: Adding one account number into an array

Anonymous — Fri, 01 Feb 2013 16:05:06 GMT

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

I'd like it to show

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

Can anyone help?