replication

Hi,

I have thousands of rows, just one column.

Basically I want to transform from
A
B
C


to

equivalent rows of each cell; e.g.
A
A
A
B
B
B
C
C
C

Do I need to write Macro to accomplish that? Sorry, I am new to Macro.3

Thanks so much.

Wei