[bombcar]

Selecting a blank column and pasting did exactly what I wanted (same value in each cell) and so - sold!