Dear Carl,

Assuming your data table is in range A1:D5, try the following formula:

=INDEX($A$1:$D$5,ROW(A2),COLUMN(B1))

Regards,

Ashish Mathur

"carl" wrote:

I have my data in a table like this:

Data Table BOX017 BOX060 BOX161
A 109
B 38275 4
C
D

I am trying to find a formula to use in the body of this new table that will
give the results below:

New Table BOX017 BOX060 BOX161 BOX226
A 0 109 0 0
B 38275 0 4 0
C 0 0 0 0
D 0 0 0 0

Thank you in advance.