Extract the data form Raw Data

[bizysoft]

Dear Members and Friends,

I have a raw sales data and I need a output result as per the format given.

I have tried $A$1 but i could not use this for all the cells.

Pls suggest the suitable formula.

:)

Mk

[#2]

@bizysoft 

See the attached sample workbook.

The formulas have been entered in the first block L3:P8.

This block can be copied to L9, L15, etc., as far as needed.

[#3]

Dear Hans Vogelaar,

Thank you for your kind effort to make the workbook with my data.

You dont understand how you saved me with this formula. I got the result from 571 invoices within fraction of minute.

Once again thank you for your help on this matter.

Bye :)