Linking question
 

Sheet 1:

Column A Column B Column C
Washington Blvd $1,500 1,000
Lincoln Ave $1,000 500

On sheet 1, I would like to see it look like this:
Washington Blvd $1,500
Washington Blvd 1,000
Lincoln Ave $1,000
Lincoln Ave 500

And so on - My sheet 2 has many rows to try and mannually link.

Thanks in advance