Divide Line Item data

Hi All,

I have the following data in a flat file,

M100 56842 10 WC_M100 LSMW_003 BSC_QL_1

LSMW_004 BSC_QL_1 LSMW_005 BSC_QL_1

20 WC_D275 LSMW_001 BSC_QL_1

LSMW_002 BSC_QL_1

M100 56850 10 WC_M100 LSMW_001 BSC_QL_2

LSMW_003 BSC_QL_2

20 WC_D275 LSMW_002 BSC_QL_2

Here M100, 56842 are headers and 10 and WC_M100 and 20 WC_D275 are line items and for WC_M100: LSMW_003, LSMW_004, LSMW_005 are different line items, and so on.

How do we convert the data into header and different line items.

Can you please explain, i appreciate an immediate answer and i will give points.

Regards,

Prabhakar