|
Copy data to all cells in group
1 Attachment(s)
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 |
Copy data to all cells in group
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 |
Copy data to all cells in group
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 sorry the formula in my first response is incorrect. use =IF(A2="",B1,A2) |
| All times are GMT +1. The time now is 06:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com