Macro to autofill cells and delete some rows and columns

I better start with saying that I'm an Excel rookie, so I know very little (next to nothing) about macro programming, and I only know basic formulas.

I have a set of data with a large number of rows, and I only need the rows that has data in column C. Therefore I would like to delete all rows, where the cell in column C is empty, to make the data set smaller for the calculations in the other sheets.
First, however, I would like to fill column L with numbers, so that it automatically fills a given cell i column L with the number in the cell above, unless that row has the value "1" in column A.

I attached the file to make it easier to understand, as English is not my first language, so it possibly could be difficult to understand what I mean...

This is a list of plays in american football games. The column A is the play number of every game, and in column L the first play of each game has the game #. So I want the game number to be filled into all rows of that game, but when the next game starts (column A has the value "1" again) the new game # should be filled to all the plays of that game and so on. All the text notes in column L can be overwritten, they are not used for anything in this document.
Then I would like to delete all plays that has no penalties (column C), to make the data set smaller, as it shall be used for penalty statistics, so I only need the plays with penalties. Finally I would like it to delete columns B, I, J, K, M and N as they are not used for anything in this document.

The macro should be able to put in a button that is placed in the "sheet1" sheet, as the whole "data" sheet is imported from a website, so if the button is placed there, it will be deleted when I get a new data set from the website, as more games are played.

I hope that it is understandable...

PlaylistData_W1-W17.xlsx

Thanks a lot for your help! Can it be done so the cell filling in column L is done before the row deletion? As there is no penalties on the first play, then the line with the play number (which is what I want copied) will be deleted before we copy the game number to all the other rows. And can it be done so it refers to a sheet called "data" so I can run the macro from another sheet?

And is there a faster way of doing the autofilling in column L? Even though it down to 544 lines after the row deletion, it takes quite some time, and if we have to do it before the row deletion to still have the game numbers, then it will take forever with around 8000 lines at the end of the season

I tried to understand the code to see if I could move around the lines myself, but most of it is gibberish to me

Now it works more or less instantly, so much faster! I don't know why it was so slow before, but I could literally see each line being filled one by one

It's still not the game numbers that it fills in column L though, I get a mix of the other notes (screenshot attached). Don't know why... It should be the 6-digit number in each of the play # "1" rows (103xxx)
Playlistdata.jpg

I'm going to bed now, so I won't reply to the thread until tomorrow or monday. I really appreciate your help, and maybe I even start to understand what the code is doing if I study it really hard

Perfect! Thank you so much!

And no, the game notes are only used on the website where the data is imported from, so in the excel document I don't need them.

Awesome, then I can maybe figure out what it actually does, and learn something
Thank you so much for your help!