My data table is set up like so:

Data BOX1 BOX3 BOX5
ABC 3 1 2
DEF 1 7
HIJ 2 1

I am trying to find a formula for the body of the table below that will give
the following results. I think I need to use the INDEX and Match functions
but not su

New Table BOX1 BOX2 BOX3 BOX4 BOX5
ABC 3 0 1 0 2
DEF 0 0 1 0 7
HIJ 2 0 1 0 0
KLM 0 0 0 0 0

Thank you in advance.