Furface, with your actual data layout, I cannot come up with a solution. There is probably one, but beyond my Excel knowledge.
I would suggest using a Userform to enter data in columnar form.
It then is quite easy to extract what you need.

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post