How to organize and insert blank cells between a huge number of data?

tareq · #1 09-23-2010, 12:32 PM

Hey guys, I am a MSc graduate, I am now working on a climate date from 1994 till 2010, they are on excel sheet with about 920,700 rows. I have the daily data for 26 weather station, each station measures about 10 parameters, but there are missing data in some days, and I need to add a blank in the missing day so we will estimate it later. Simply, the situation is like this example: You have the following data:
1

2
4
5
7
9
10
These numbers are in one column (A).
I also created the standard column (B) as follow:
1
2
3
4
5
6
7
8
9
10
Now I need to put these "A" and "B" beside each other and edit column "A" according to column "B", so I will insert a blank to replace the missing data, so "B" will not change, while "A" will be like this
1
2
blank cell
4
5
blank cell
7
blank cell
9
10
Any way, attached is my example in an excel file, there 2 sheets in the file, the first sheet "Before" is the data I have plus the standard column I created, and the second sheet "After" contains the unchanged column "B" with the edited column "A" according to column "B"
My question is there any function can do this automatically for the around 1 million cell I have??? If not, is there any add IN will help?? or can I even create add IN that will do that? If nothing works, is there any office application or any other software allows me to edit my data in the way I need?? I REALLY NEED YOUR HELP GUYS!! AND ASAP!!!!

Please Note that I have at home Excel 2007 with OS windows 7 32bit and at the University I have Excel 2010 with OS windows vista 64bit, but the file attached is in ".xls" format since this forum dosn't support uploading ".xlsx" format.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Bar chart help urgent ?????	aligahk06	Excel	1	07-08-2010 12:23 AM
Bar chart help urgent ?????	aligahk06	Project	0	07-03-2010 06:58 AM
Urgent help regarding automation.	aligahk06	Excel	1	01-14-2010 01:55 PM
Urgent Help Required	id12345	Word	4	12-29-2009 08:22 AM
Urgent help!	captainspi	Word	2	04-19-2009 11:17 AM