If I understand this correctly, you have the first two columns , then account
1 + amt , account 2 + amt, etc. How long is your data?
you could copy a1:d99 assuming you have 99 lines which would get the first
set, then copy a1:b99 to a100, then e1:f99 to c100 which would get the 2nd
account
etc

you would end up with 3X the number of lines then you could sort by alpha
number. To keep track , I think I would have the first column tell me if it
was for account 1 or account 2 or account 3

you could do this with VB, but depends how much data and how slick you want it

good luck

"KWhamill" wrote:

I have this spreadsheet i need to turn into a txt file for an database
uploader. It Looks like this;
Alpha Number ID Account1 amt account2 amt account3 amt
What I need is this;
Alpha Number ID Account1 amt
Alpha Number ID Account2 amt
Alpha Number ID Account3 amt
What i thought was the obvious solution isn't working. I was wondering if
anyone has done a macro that might untangle this.