Transpose Data from one sheet to another

[chorina13]

I have two excel sheets, one being the data input sheet, and the other the calculations sheet.
On the data input, I have attached a copy showing three columns with data (B, actual date of the event, C, the distance in Kms, & D, showing the time.
What I am trying to do is match the date and the distance over the the calculations sheet where the date column shows all the dates for a complete year, and what I am having issues with is I cannot figure out the formula
so as to line the datasheet dates and distance to the calculation sheets date and Distance.
Have attached a short copy of both sheets, so hopefully someone can understand what I am trying to achieve.
Thank you in advance

 

[awoohaw]

This suggestion is all in one sheet, and I've just created my own values instead of manually typing in yours. But, I hope you get the idea.
Please try this:

Book1
	A	B	C	D	E	F	G	H
1
2		Date	Dist	Time		Date	Dist	Time
3		2024-01-01	8.95	01:02:18		2024-01-01	8.95	01:02:18
4		2024-01-02	11.09	01:13:32		2024-01-04	8.85	01:07:26
5		2024-01-03	10.34	01:14:14		2024-01-07	14.72	01:47:19
6		2024-01-04	8.85	01:07:26		2024-01-10	13.76	01:32:28
7		2024-01-05	12.53	01:24:12		2024-01-13	13.72	01:34:32
8		2024-01-06	7.71	00:54:49
9		2024-01-07	14.72	01:47:19
10		2024-01-08	14.03	01:27:58
11		2024-01-09	9.54	01:08:53
12		2024-01-10	13.76	01:32:28
13		2024-01-11	7.49	00:57:45
14		2024-01-12	12.93	01:22:53
15		2024-01-13	13.72	01:34:32
16		2024-01-14	8.4	01:00:39
17		2024-01-15	8.69	00:57:16
18		2024-01-16	14.2	01:37:33
19		2024-01-17	8.92	00:58:42
20		2024-01-18	13.82	01:43:14
21		2024-01-19	7.64	00:53:06
22		2024-01-20	14.68	01:35:43
Sheet3

Cell Formulas
Range	Formula
G3:H7	G3	=INDEX($C$3:$D$22,MATCH($F3,$B$3:$B$22,0),0)
Dynamic array formulas.

This will not work if you have multiple distances on the same day, but the formula can be adjusted with a change in the formula
to in the 3rd column.

=INDEX($D$3:$D$22,MATCH($F3&$G3,$B$3:$B$22&$C$3:$C$22,0))

 

[chorina13]

I am sorry but am a little confused with your response, I realize that you are using one sheet to give your answer, but your columns C & D at the start would normally empty, with B filled up with the daily date for one year, on another sheet for Calculation, until the date is entered on the RideLog Data Input..
Your columns F, G and H are the known factors in the Ridelog Data Input sheet. What I can not follow is where did the results in Columns C & D Rows 4 & 5, 7 & 8 come from when there is no results or time for those days on the RideLog Data Input Sheet.
I tried your formula a number of ways and keep getting #N/A..
Thanks gain for your help.

 

[awoohaw]

I guess I got the input and calculation backwards.

Try this:

Book1
	A	B	C	D	E	F	G	H
1
2		Date	Dist	Time		Date	Dist	Time
3		2024-01-01	8.95	01:02:18		2024-01-01	8.95	01:02:18
4		2024-01-02				2024-01-04	8.85	01:07:26
5		2024-01-03				2024-01-07	14.72	01:47:19
6		2024-01-04	8.85	01:07:26		2024-01-10	13.76	01:32:28
7		2024-01-05				2024-01-13	13.72	01:34:32
8		2024-01-06
9		2024-01-07	14.72	01:47:19
10		2024-01-08
11		2024-01-09
12		2024-01-10	13.76	01:32:28
13		2024-01-11
14		2024-01-12
15		2024-01-13	13.72	01:34:32
16		2024-01-14
17		2024-01-15
18		2024-01-16
19		2024-01-17
20		2024-01-18
21		2024-01-19
22		2024-01-20
23
Sheet1

Cell Formulas
Range	Formula
C3:D3,C15:D15,C12:D12,C9:D9,C6:D6,C4:C5,C7:C8,C10:C11,C13:C14,C16:C22	C3	=FILTER($G$3:$H$7,$F$3:$F$7=B3,"")
Dynamic array formulas.

 

[chorina13]

WOW! That is just GREAT! It does exactly what I was after, Thank You very much

 

[awoohaw]

My pleasure. Thanks for the feedback. My apologies for the confusion.

Best Wishes!!!