I regularly receive a PDF which I can convert to an eXcel document but the format is not one amenable to the tasks I perform next for my golf buddies. I know that the formula experts here can easily solve this dilemma from the attached - the input is in the left 3 columns, the usable (desired) output is in the right 3.
Your help will be really appreciated!

Attached Files

Challenge1.xlsx (9.5 KB, 6 views)