I have a query in the correct format but need some column names changed. It can be done manually, but I'd like to do it automatically. Attached are two screenshots, one with no header, the other has header names that were manually entered.
The query is of two 18 hole golf courses, that contains hole information (Par, hole handicap (both men and women)) for each course. Having the course name in a separate column, I want to arrive at naming the columns as demonstrated in the second screenshot
Here is the link to see the screenshots: https://www.dropbox.com/sh/x9ns177mmjcn25m/AAB5BkzTzWuGFm1wS-1NY-Rqa?dl=0
Hi Sal,
Please see attached. Note: I had to recreate your file so the figures are random and won't match yours, but you should still get the ideal.
Mynda
Hi Mynda,
Very helpful, thank you.
Sal