How to create detail invoice from data rows

[heryx]

Hi ,

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	.

<tbody>
</tbody>

 

[heryx]

Hii guys,

I'm try using index array for extract the invoice number (unique) but still no solution for add the item no after invoice no.

Thanks