Need help auto filling data into empty cells based on a pattern of data within same range

If your data start in A1
B1, B2, ... can be found using the formula

Formula:

Please Login or Register  to view this content.

and copy to the right
A3, A4, ... can be found using the formula

Formula:

Please Login or Register  to view this content.

and copy down
similary you can found B3, B4, ...

Thanks, that method seems very manual. Was hoping for something more automatic if possible. The sample is very small part of larger spreadsheet. I tried to upload Excel file but upload is taking forever. Can't upload image either. In the sample above the date is lining up correctly with the rows, but not the columns so please consider that. Thanks.

Please send a sample file. I dont Know where is 6.350.

Assuming that the initial data are
A2=50.0; B1=80 ; B2=6.750
you can fill the table from C3 with the formula

Formula:

Please Login or Register  to view this content.

The formula is valid for the right and down

Sample 1.xlsx

Here is the file but had to use older version of Excel from another computer to be able to upload file. Known values are on the spreadsheet and are relative to the column headers and row headers. Need to figure out the values of the other cells from known values. Each color coded grid has to stand on its own so can't use values from one color grid to calculate from the other.

Never mind guys. I figured it out. Thankyou though.

You can use the array formula

Formula:

Please Login or Register  to view this content.

to find the formula to apply.
See the file