multiple Accounts in data file

Hello Experts,

I am using BPC NetWeaver 7.0 SP6

Has anyone discovered a way to import data form a delimited file where account data is stored in their own column? Or are we stuck with the verticle approach?

For instance, I want to import data for multiple accounts from a file that looks like this:

CATEGORY DEPARTMENT TIME DATASRC ACCOUNT1 ACCOUNT2 ACCOUNT3 ACCOUNT4 ACCOUNT5

ACTUAL 123 2009.JAN GLSYS 25 700 566

ACTUAL 123 2009.JAN GLSYS 97 568 544 9

ACTUAL 123 2009.JAN GLSYS 257 897 488 2

ACTUAL 456 2009.FEB GLSYS 958 6

ACTUAL 456 2009.FEB GLSYS

ACTUAL 456 2009.FEB GLSYS 365 12300 1200 14

I know you can use MVAL for the multiple time periods, but I do not think that will work for accounts.

Any assistance anyone can provide would be much appreciated.

Thank you,

Mark Glowczewski