One way:

In T1, enter

=IF(A1<"", A1,"")

copy down as far as desired.


In article ,
"RW" wrote:

Say I have a 20 column wide spread sheet- columns 'A' ~ 'T'.

When I enter data into the cell at row 1 / column 'A', is there a way to
have that data automatically populate the cell at row 1 / column 'T'?

And if it can be done with cells, can it also be done with entire rows and
columns?