I hope this is the right place to post this question.

I have an interesting problem. I have a bunch of over a thousand rows full of data.

I need to duplicate each row and paste it directly below itself. Manually, this would require inserting a row, then copying and pasting the row above.

So it looks like this

1 Somedatahere
2 Bunchofnumbers
3 Blablabla

and I was wondering if I could make it look like this without one and a half thousand copy-pastes:

1 Somedatahere
2 Somedatahere
3 Bunchofnumbers
4 Bunchofnumbers
5 Blablabla
6 Blablabla

Each number representing a row.

Any idea how I would go about doing that?

Or at the very least, is there any way to insert a row between every adjacent row for a large block of rows?

Thanks.