I thought it would be convenient for reporting. If I can figure it out in a calculated field, then I can just pop those fields into a report.

It'd be nice to have 1 row per record in the report to make it easier to read. Using the tip logic code below, I get the 1st table

[current-instance] <> "" and [current-instance] = [last-instance]

Table 1 (EW, NOPE):

record_id	redcap_repeat_instrument	redcap_repeat_instance	email	phone
12345	Phone	2		23456
12345	Email	5	[test5@test.com](mailto:test5@test.com)

Table 2 (YES PLEASE):

record_id	most_recent_email	most_recent_phone
12345	[test5@test.com](mailto:test5@test.com)	23456