Spreadsheet: 690759d1597269514-lookup-trying-to-deglitch-repeats-in-data-smalladviced
Sheet: Sheet1

 |  | Reading date:
 | 2020-01-01 00:00:00 | 2020-04-07 00:00:00 | 2020-04-13 00:00:00 | 2020-05-01 00:00:00 | 2020-05-08 00:00:00 | Age at reading: | 7 | 8 | 9 | 10 | 11 | 12 | 13 | Weeks
Week in year to read day:
 | DOB
Mouse A | 2020-02-07 00:00:00 |  |  | 40 | 50
[NAME] | 2020-02-07 00:00:00 |  | 30 | 40 | 50
C | 2020-02-07 00:00:00 | 20 | 30 | 640 | 50
D | 2020-02-07 00:00:00 | 20 | 30 | 1 | 50
E | 2020-02-07 00:00:00 | 20 | 30 | 0 | 50
F | 2020-02-07 00:00:00 | 20 | 30 |  | 50
G | 2020-02-07 00:00:00 | 20 |  | 40 | 50
H | 2020-02-07 00:00:00 | 20 | 30
I | 2020-02-10 00:00:00 | 20 | 30 | 40 | 50
 | Age at reading date line 2
 | 2020-02-07 00:00:00
 | 2020-02-10 00:00:00
What I'm trying to do, is to get the mouse's glucose reading data from the left section, and put it in the right section sorted by the number of weeks since the mouse was born. After the mouse name (Column A:  A, B, C…) is the DOB (date of birth) of the mouse. Under "Reading date" is the date a glucose reading was taken for the mouse. Below the reading dates are the glucose readings  (20. , 30. , 40. ...). At the right side, I want so see these glucose readings sorted by the mouse's age in weeks at the reading day. Above is the more simple LOOKUP formula. Below is with stuff added to avoid display of errors and zeros where there is no data.        "Week in year to read day" is how many weeks from the 1/1/2020 until the reading date.  (Below to help me figure it out, is  'Age at reading date line 2' is how many weeks from the birth date given at left to the reading date of that column.)
 |  | Reading date:
 | 2020-01-01 00:00:00 | 2020-04-07 00:00:00 | 2020-04-13 00:00:00 | 2020-05-01 00:00:00 | 2020-05-08 00:00:00 | Age at reading: | 7 | 8 | 9 | 10 | 11 | 12 | 13 | Weeks
Week in year read:
 | DOB
Mouse A | 2020-02-07 00:00:00 |  |  | 40 | 50
[NAME] | 2020-02-07 00:00:00 |  | 30 | 40 | 50
C | 2020-02-07 00:00:00 | 20 | 30 | 640 | 50
D | 2020-02-07 00:00:00 | 20 | 30 | 1 | 50
E | 2020-02-07 00:00:00 | 20 | 30 | 0 | 50
F | 2020-02-07 00:00:00 | 20 | 30 |  | 50
G | 2020-02-07 00:00:00 | 20 |  | 40 | 50
H | 2020-02-07 00:00:00 | 20 | 30
I | 2020-02-10 00:00:00 | 20 | 30 | 40 | 50
 | Age at reading date line 2
 | 2020-02-07 00:00:00
 | 2020-02-10 00:00:00
How it should look:  [NAME] are changes from above where there were problems. It doesn't need to look exactly like this, but this is the data I want to see.
 |  | Reading date:
 | 2020-01-01 00:00:00 | 2020-04-07 00:00:00 | 2020-04-13 00:00:00 | 2020-05-01 00:00:00 | 2020-05-08 00:00:00 | Age at reading: | 7 | 8 | 9 | 10 | 11 | 12 | 13 | Weeks
Week in year read: |  | 13.85714285714286 | 14.71428571428571 | 17.28571428571428 | 18.28571428571428 |  | . | . | . | . | . | . | . | .
 | DOB
Mouse A | 2020-02-07 00:00:00 |  |  | 40 | 50 |  |  |  |  |  |  | 40 | 50
[NAME] | 2020-02-07 00:00:00 |  | 30 | 40 | 50 |  |  |  | 30 | (empty) | (empty) | 40 | 50
C | 2020-02-07 00:00:00 | 20 | 30 | 640 | 50 |  |  |  | 20, 30 | (empty) | (empty) | 640 | 50
D | 2020-02-07 00:00:00 | 20 | 30 | 1 | 50 |  |  |  | 20, 30 | (empty) | (empty) | 1 | 50
E | 2020-02-07 00:00:00 | 20 | 30 | 0 | 50 |  |  |  | 20, 30 | (empty) | (empty) | 0 | 50
F | 2020-02-07 00:00:00 | 20 | 30 |  | 50 |  |  |  | 20, 30 | (empty) | (empty) |  | 50
G | 2020-02-07 00:00:00 | 20 |  | 40 | 50 |  |  |  | 20 |  |  | 40 | 50
H | 2020-02-07 00:00:00 | 20 | 30 |  |  |  |  |  | 20, 30 | (empty) | (empty)
I | 2020-02-10 00:00:00 | 20 | 30 | 40 | 50 |  |  | 20 | 30 | (empty) | (empty) | 40 | 50
 | Age at reading date line 2
 | 2020-02-07 00:00:00 | 8.57142857142857 | 9.428571428571429 | 12 | 13
 | 2020-02-10 00:00:00 | 8.142857142857142 | 9 | 11.57142857142857 | 12.57142857142857