need a basic formula

Copper Contributor

I have a large client sales list, and want to populate the cell below A2 with data from cell above A1, 

2 Replies

@Brian1230 

Then, in A2 enter:

=A1

and copy it all the way down.

 

 

 

 

In A2 cell write this formula =A1