How can I automate double clicking the bottom right corner of all of the cells in a list/table?

[Waboku]

Hello,

Thank you for considering my question. I am making a spreadsheet that involves a lot of double clicking the bottom right corner of cells. It would save me, I think, a few days to be able to automate doing that. To be more specific I made examples below of before and after of what I would like to automate.

Before:

Event	Name	Data
1	Waboku1	1
		2
		3
	Waboku2	1
		2
2	Waboku1	1
		2
	Waboku2	1
		2

<tbody>
</tbody>

After:

Event	Name	Data
1	Waboku1	1
1	Waboku1	2
1	Waboku1	3
1	Waboku2	1
1	Waboku2	2
2	Waboku1	1
2	Waboku1	2
2	Waboku2	1
2	Waboku2	2

<tbody>
</tbody>

I'm sorry I don't know how to make the above look like a spreadsheet.

 

[RedBeard]

CTRL + D should autofill a selection. Does this not work?

 

[Waboku]

CTRL + D should autofill a selection. Does this not work?

When i tried using control + D just now the spreadsheet auto filled the first cell down to the last filled cell to the right of the column. It didn't autofill the next name on the list instead it just autofilled the previous name over it to the end of the list.

for example,

before:
Name 1
blank
Name 2
blank

after
Name 1
Name 1
Name 1
Name 1

Thanks for considering helping me with this.