How to create detail invoice from data rows

Hi :help:


I need help to create detail invoice from data rows below :
What formula to get data (A1:C5) in cell A9,A10,A11....


Thanks


A B C
1 Invoice No Item No Item Desc
2 PSI0001 STBX0001 Item Desc 0001
3 PSI0001 STBX0002 Item Desc 0002
4 PSI0002 STBX0003 Item Desc 0003
5 PSI0002 STBX0004 Item Desc 0004
6 .
7
8 Invoice No
9 PSI0001
10 STBX0001
11 STBX0002
12 PSI0002
13 STBX0003
14 STBX0004
15 .

heryx said:

What formula to get data (A1:C5) in cell A9,A10,A11....

Click to expand...

Please upload your example files with the data and desired results.
The faster we help you

navic said:

Please upload your example files with the data and desired results.
The faster we help you

Click to expand...

Hi Navic,

Example files below, thank you.
View attachment Detil Invoice Line.xlsx

Try this ARRAY formula (for all column range)
see attach example

navic said:

Try this ARRAY formula (for all column range)

Code:

=IFERROR(INDEX($B$2:$B$18;SMALL(IF($E$1=A2:A18;ROW(B2:B18)-1;"");ROW()-1));"")

see attach example

Click to expand...

Hi Navic,

Thanks for ARRAY formula, actually i need to extract the unique field "Invoice Number" then the "Item No" in the same rows.

See attach file

View attachment heryx-navic.xlsx

Thanks again

heryx said:

......... in the same rows.

Click to expand...

I guess you think the one column/multiple rows?
Try to look for a solution using VBA or you wait till you hear from someone else.
Unfortunately I can not help you for this

heryx, you can try Pivot Table (see attach)