View Single Post
  #1   Report Post  
carl
 
Posts: n/a
Default INDEXing Question

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.