Please forgive me, I'm relativelty new to pilot scripting or any scripting come to mention it.  The probelm I have is that I've data in excel files that I'd like to run through a reporting protocol but the heading row is not in row1.  On top of that, one of the columns doesn't yet have a title.

So my two questions are

1 - How do I remove unwanted rows above where my property titles are

and

2 - How do I name/rename a blank cell/property

**

Example file attached - Ideally I'd like to remove row1 with row2 containing the property headings.  A2 requires a title.

Cheers