Repeat the item in the list.

[srizki]

Repeat the items:
I have our company interest in corresponding cell that I need to repeat, so,
[TABLE="width: 72"]
<tbody>[TR]
[TD]
[/TD]
[/TR]
[TR]
[TD]0.50882
[/TD]
[/TR]
[TR]
[TD]1.59915
[/TD]
[/TR]
[TR]
[TD]1.59915
[/TD]
[/TR]
[TR]
[TD]1.62267
[/TD]
[/TR]
[TR]
[TD]1.59915
[/TD]
[/TR]
[TR]
[TD]1.62267
[/TD]
[/TR]
[TR]
[TD]0.52931
[/TD]
[/TR]
[TR]
[TD]1.6075
[/TD]
[/TR]
[TR]
[TD]0.50882
[/TD]
[/TR]
</tbody>[/TABLE]
Will become,
[TABLE="width: 64"]
<tbody>[TR]
[TD]0.50882
[/TD]
[/TR]
[TR]
[TD]0.50882
[/TD]
[/TR]
[TR]
[TD]1.59915
[/TD]
[/TR]
[TR]
[TD]1.59915
[/TD]
[/TR]
[TR]
[TD]1.59915
[/TD]
[/TR]
[TR]
[TD]1.59915
[/TD]
[/TR]
[TR]
[TD]1.62267
[/TD]
[/TR]
[TR]
[TD]1.62267
[/TD]
[/TR]
[TR]
[TD]1.59915
[/TD]
[/TR]
[TR]
[TD]1.59915
[/TD]
[/TR]
[TR]
[TD]1.62267
[/TD]
[/TR]
[TR]
[TD]1.62267
[/TD]
[/TR]
[TR]
[TD]0.52931
[/TD]
[/TR]
[TR]
[TD]0.52931
[/TD]
[/TR]
[TR]
[TD]1.6075
[/TD]
[/TR]
[TR]
[TD]1.6075
[/TD]
[/TR]
[TR]
[TD]0.50882
[/TD]
[/TR]
[TR]
[TD]0.50882
[/TD]
[/TR]
</tbody>[/TABLE]

What is the fastest way of doing this? I have been manually adding space and then using F5 blank and =up arrow, enter to do this.
Thanks.

 

[Joe4]

One quick and easy way that does not require any VBA is to do the following.
Insert a helper column. Enter 1 in the first row, 2 in the second row, and then autofill down for all rows.
Then highlight and copy these two columns of data for just the populated rows, and paste just below the last row.
Then, sort it my your helper column.
You can then delete the helper column at that point, if you like.

 

[srizki]

Thank you Joe, I appreciate.

Best regards,

 

[Sharid]

this might help https://www.mrexcel.com/forum/excel-questions/444034-how-duplicate-rows-excel.html

 

[srizki]

Thank you JUBA