On Tuesday, August 12, 2014 11:47:59 AM UTC-7, Cywy wrote:
Hi All,



I have a very large spreadsheet (over 21k rows) that I need help with.

I need the data in column A to copy to each row in the section. A

sample spreadsheet is attached with my desired results.



Thanks in advance





+-------------------------------------------------------------------+

|Filename: samplecfw.txt |

|Download: http://www.excelbanter.com/attachment.php?attachmentid=982|

+-------------------------------------------------------------------+







--

Cywy

add another column right after column A and use this formula to populate all the way down. Then copy column B and paste the values (paste special) into column A.

=IF(A2="",A1,A2)

Gary