SOLVED

Adding Partial rows to a column for many many entries

%3CLINGO-SUB%20id%3D%22lingo-sub-3014384%22%20slang%3D%22en-US%22%3EAdding%20Partial%20rows%20to%20a%20column%20for%20many%20many%20entries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3014384%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%20Lets%20Assume%20I%20have%20a%20column%20(1%2C2%2C3%2C4%2C5%2C6%2C7%2C8%2C9)%20and%20another%20column%20(5%2C3%2C2%2Cgap%2C1%2C21%2C4%2Cgap%2C5%2C6%2C82)%20-%20they%20are%20both%20have%209%20entries%2C%20just%20one%20of%20them%20has%20gaps.%20How%20do%20I%20automatically%20insert%20the%20gaps%20from%20the%20second%20column%20(e.g%20blank%20entry%20after%20entry%203%2C%20and%20blank%20entry%20after%20entry%206)%20into%20the%20first%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20be%20able%20to%20apply%20the%20blank%20entries%20from%20one%20column%20that%20is%20actually%2035000%20entries%20long%20(with%20gaps%20already)%2C%20to%20another%20column%20which%20is%20about%2034000%20entries%20long%20(without%20gaps)%2C%20so%20that%20they%20have%20the%20same%20number%20of%20entries%2C%20and%20gaps%20in%20the%20same%20place.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20ever%20so%20much%20for%20your%20help%2C%20I%20am%20really%20stuck%20and%20any%20advice%20is%20really%20appreciated.%20if%20you%20have%20any%20questions%20about%20my%20problem%20please%20let%20me%20know!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3014384%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3014510%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20Partial%20rows%20to%20a%20column%20for%20many%20many%20entries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3014510%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1232475%22%20target%3D%22_blank%22%3E%403456rh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20what%20you%20are%20looking%20for%3F%20The%20result%20column%20is%20E%20and%20the%20row%20without%20gaps%20is%20A.%20I%20made%20a%20test%20for%201000%20entries%20in%20column%20A%20and%20it%20seems%20to%20work.%20Click%20on%20the%20button%20in%20cell%20G2%20to%20start%20the%20macro.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3014529%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20Partial%20rows%20to%20a%20column%20for%20many%20many%20entries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3014529%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1232475%22%20target%3D%22_blank%22%3E%403456rh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIs%20this%20what%20you%20are%20looking%20for%3F%20The%20result%20column%20is%20E%20and%20the%20column%20without%20gaps%20is%20A.%20I%20made%20a%20test%20for%201000%20entries%20in%20column%20A%20and%20it%20seems%20to%20work.%20Click%20on%20the%20button%20in%20cell%20G2%20to%20start%20the%20macro.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3014805%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20Partial%20rows%20to%20a%20column%20for%20many%20many%20entries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3014805%22%20slang%3D%22en-US%22%3Ewow!%20thanks%20so%20much!%20you%20don't%20understand%20how%20helpful%20that%20is!%20really%20appreciate%20it!%20What%20adjustments%20would%20I%20have%20to%20make%20so%20that%20the%20gaps%20in%20the%20column%20with%20gaps%2C%20could%20be%20applied%20to%20a%20range%20of%20columns%3F%20for%20example%2C%20in%20my%20problem%20I%20have%2019%20columns%20of%20data%20without%20gaps%2C%20and%20I%20need%20to%20put%20the%20gaps%20into%20all%20of%20them!%20thanks%20again%20for%20this!%20very%20helpful!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3015061%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20Partial%20rows%20to%20a%20column%20for%20many%20many%20entries%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3015061%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1232475%22%20target%3D%22_blank%22%3E%403456rh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIs%20this%20what%20you%20are%20looking%20for%3F%20I%20added%20a%20second%20sheet%20(Tabelle2).%20The%20result%20columns%20are%20W%20to%20AO%20and%20the%20columns%20without%20gaps%20are%20A%20to%20S.%20Column%20with%20gaps%20is%20column%20U.%20I%20made%20a%20test%20for%202000%20entries%20in%20columns%20A%20to%20S%20(and%20in%20column%20U)%20and%20it%20seems%20to%20work.%20Click%20on%20the%20button%20in%20cell%20T2%20to%20start%20the%20macro.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi there, Lets Assume I have a column (1,2,3,4,5,6,7,8,9) and another column (5,3,2,gap,1,21,4,gap,5,6,82) - they are both have 9 entries, just one of them has gaps. How do I automatically insert the gaps from the second column (e.g blank entry after entry 3, and blank entry after entry 6) into the first? 

 

I need to be able to apply the blank entries from one column that is actually 35000 entries long (with gaps already), to another column which is about 34000 entries long (without gaps), so that they have the same number of entries, and gaps in the same place.

 

Thanks ever so much for your help, I am really stuck and any advice is really appreciated. if you have any questions about my problem please let me know!!

4 Replies
best response confirmed by 3456rh (New Contributor)
Solution

@3456rh 

Is this what you are looking for? The result column is E and the column without gaps is A. I made a test for 1000 entries in column A and it seems to work. Click on the button in cell G2 to start the macro.

wow! thanks so much! you don't understand how helpful that is! really appreciate it! What adjustments would I have to make so that the gaps in the column with gaps, could be applied to a range of columns? for example, in my problem I have 19 columns of data without gaps, and I need to put the gaps into all of them! thanks again for this! very helpful!

@3456rh 

Is this what you are looking for? I added a second sheet (Tabelle2). The result columns are W to AO and the columns without gaps are A to S. Column with gaps is column U. I made a test for 2000 entries in columns A to S (and in column U) and it seems to work. Click on the button in cell T2 to start the macro.

Hi again, just on my work account at the moment. Just wanted to say thank you, that sorted my issue out perfectly. Really appreciate the help!