Formula to Extract relevant data

for S.No at G7
=IF(ROW(1:1)>COUNT($A$4:$A$20),"",ROW(1:1))
copy down

for Location at H7
=IF(LEN($G7);INDEX(B$4:B$20;MATCH($G7;$A$4:$A$20;0)))

copy down and right to fill column Name and Amount