Extract the data form Raw Data

%3CLINGO-SUB%20id%3D%22lingo-sub-1936063%22%20slang%3D%22en-US%22%3EExtract%20the%20data%20form%20Raw%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1936063%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Members%20and%20Friends%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20raw%20sales%20data%20and%20I%20need%20a%20output%20result%20as%20per%20the%20format%20given.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20%24A%241%20but%20i%20could%20not%20use%20this%20for%20all%20the%20cells.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Untitled.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F236347i2AD0EA46469B9892%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Untitled.jpg%22%20alt%3D%22Untitled.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EPls%20suggest%20the%20suitable%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3EMk%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1936063%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1936134%22%20slang%3D%22en-US%22%3ERe%3A%20Extract%20the%20data%20form%20Raw%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1936134%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F883601%22%20target%3D%22_blank%22%3E%40bizysoft%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20the%20attached%20sample%20workbook.%3C%2FP%3E%0A%3CP%3EThe%20formulas%20have%20been%20entered%20in%20the%20first%20block%20L3%3AP8.%3C%2FP%3E%0A%3CP%3EThis%20block%20can%20be%20copied%20to%20L9%2C%20L15%2C%20etc.%2C%20as%20far%20as%20needed.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1937971%22%20slang%3D%22en-US%22%3ERe%3A%20Extract%20the%20data%20form%20Raw%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1937971%22%20slang%3D%22en-US%22%3E%3CP%3EDear%26nbsp%3BHans%20Vogelaar%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20kind%20effort%20to%20make%20the%20workbook%20with%20my%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20dont%20understand%20how%20you%20saved%20me%20with%20this%20formula.%20I%20got%20the%20result%20from%20571%20invoices%20within%20fraction%20of%20minute.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnce%20again%20thank%20you%20for%20your%20help%20on%20this%20matter.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBye%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

 

Untitled.jpg

Pls suggest the suitable formula.

 

Mk

2 Replies

@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.

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