79084470

Date: 2024-10-14 00:57:52
Score: 0.5
Natty:
Report link

The general formula is as follows, you can adjust to your needs:

=IF(ROW() - 1 <= COUNTA(A:A)-1, INDEX(A:A, ROW()), INDEX(B:B, ROW() - COUNTA(A:A)+1))

enter image description here

Reasons:
  • Probably link only (1):
  • Low length (1):
  • Has code block (-0.5):
  • High reputation (-1):
Posted by: Michal