Building a parts list

Glad it will work.

The INDEX and MATCH functions are quite useful. I would definitely do some research online.
Here is a breakdown of your formula:

Formula:

=IFERROR(INDEX(Sheet2!$B$3:$G$273,MATCH($A3,Sheet2!$A$3:$A$273,0),MATCH(B$2,Sheet2!$B$2:$G$2,0)),"")

Blue = the actual data from the table
Green = your row headers (in this case the helper column that is only identifying rows with a value >0 in column B)
Red = Your column headers

Remember to change the thread to solved (under thread tools).