Populating rows based on a set criteria

[excelnovice2020]

Hi, I have a simple table with 3 rows and 3 columns:
Column 1 - Order #, Column 2 - Part #, Column 3 - Quantity
Row 1: 123 | ABC | 5
Row 2: 456 | XYZ | 7
Row 3: 789 | OPQ | 2

How can I set up either a formula (preferably) or VBA to automatically populate, in a separate sheet:
5 rows of 123 | ABC, followed by
7 rows of 456 | XYZ, followed by
2 rows of 789 | OPQ

Thanks in advance,

 

[kweaver]

You can do this with a formula but it requires (a) a helper column and (b) knowing how far down to fill the F and G columns (or have to test for a 0). A2 is a 1 and filling down A3 which is: =A2+D2

VBA would be much cleaner.

Book1
	A	B	C	D	E	F	G
1	Helper	Order #	Part #	Qty		Order	Part
2	1	123	ABC	5		123	ABC
3	6	456	XYZ	7		123	ABC
4	13	789	OP!	2		123	ABC
5	15					123	ABC
6						123	ABC
7						456	XYZ
8						456	XYZ
9						456	XYZ
10						456	XYZ
11						456	XYZ
12						456	XYZ
13						456	XYZ
14						789	OP!
15						789	OP!
16						0	0
17						0	0
18						0	0
19						0	0
20						0	0
21						0	0
22						0	0
23						0	0
24						0	0
25						0	0
26						0	0
27						0	0
28						0	0
Sheet2

Cell Formulas
Range	Formula
F2:G28,A3:A5	F2	=VLOOKUP(ROW(1:1),$A$2:$B$5,2)