I have a csv file that has gaps between rows as shown below. This is just a sample as the number of rows is 30,000 so dont want to copy and paste each change of text or number to fill the blanks upto the "Sub Total". Any ideas would be appreciated?
I have attached a file for viewing.
7534300.0 -> 7534400.0
Sub Total
7534400.0 -> 7534500.0
Sub Total
Last edited by rylo; 11-07-2010 at 06:06 PM.
what is your desired output? are we just dragging the Y figures down? i.e.'7534600.0 -> 7534700.0'?
--
Regards
PD
----- Don't Forget -----
1. Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
2. Thank those who have helped you by Clicking the scales above each post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Hi
This can be done using formulas.
1) Highlight column C.
2) Edit, GoTo, Special, Blanks, OK.
3) =C2, ctrl enter
4) Highlight column C, Copy, Paste Special values.
rylo
Thanks Rylo works well.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks