View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KWhamill KWhamill is offline
external usenet poster
 
Posts: 24
Default Resorting nightmare

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.