VLOOK UP AUTO FILL UP

[Zulwaqar88]

Hello everyone,

I have stuck to find a formula for auto fill up.
1) i try to find a formula to auto list out all item in table

MASTER DATA
LOCATION	EQUIPMENT
A1	A1 01
A2	A2 02
A1	A1 03
A1	A1 04
A1	A1 05
A1	A1 06
A1	A1 07
A2	A2 03
A2	A2 04
A2	A2 05
WELD	WELD 01
WELD	WELD 02
WELD	WELD 03
WELD	WELD 04
PAINT	PAINT 01
PAINT	PAINT 02
PAINT	PAINT 03

GOAL

	LOCATION	EQUIPMENT
1​	A1	A1 01
2​	A1	A1 03
3​	A1	A1 04
4​	A1	A1 05
5​	A1	A1 06
6​	A1	A1 07
7​	A2	A2 02
8​	A2	A2 03
9​	A2	A2 04
10​	A2	A2 05
11​	WELD	WELD 01
12​	WELD	WELD 02
13​	WELD	WELD 03
14​	WELD	WELD 04
15​	PAINT	PAINT 01
16​	PAINT	PAINT 02
17​	PAINT	PAINT 03

 

[hajiali]

what are you trying to auto fill? also if you can provide more explanation to what you need done.