Home

Inserting multiple rows in between the existing data set

%3CLINGO-SUB%20id%3D%22lingo-sub-104549%22%20slang%3D%22en-US%22%3EInserting%20multiple%20rows%20in%20between%20the%20existing%20data%20set%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-104549%22%20slang%3D%22en-US%22%3E%3CP%3EHey%3C%2FP%3E%3CP%3ECan%20anyone%20tell%20me%20how%20to%20insert%20multiple%20alternating%20rows%20in%20the%20existing%20data%20set%20as%20some%20so%20the%20data%20needs%20to%20be%20sorted%20out%20and%20i%20have%20almost%2017k%20rows%20that%20need%20to%20be%20inserted.%20So%20can%20anyone%20tell%20me%20some%20way%20of%20doing%20it%20quickly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EAditya%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-104549%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%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-298806%22%20slang%3D%22en-US%22%3ERe%3A%20Inserting%20multiple%20rows%20in%20between%20the%20existing%20data%20set%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-298806%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CSPAN%3EAditya!%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI'm%20just%20writing%20to%20say%26nbsp%3BTHANK%20YOU!!!%26nbsp%3B%20I've%20been%20looking%20for%20a%20solution%20to%20solve%20this%20problem%20and%20they%20all%20were%20so%20*complicated*!%26nbsp%3B%20Your%20solution%20is%20simple%20and%20elegant.%26nbsp%3B%20I%20am%20very%20grateful%2C%20indeed!%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ELisannf%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-104789%22%20slang%3D%22en-US%22%3ERe%3A%20Inserting%20multiple%20rows%20in%20between%20the%20existing%20data%20set%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-104789%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20found%20a%20way%20to%20do%20it%2C%20i%20selected%20the%20rows%20in%20which%20i%20needed%20to%20add%20the%20alternate%20rows%20pasted%20it%20in%20another%20sheet%2C%20added%20a%20column%20gave%20numbers%20to%20it%20as%201%2C2%2C3%20and%20autofilled%20it%20till%20last%20copied%20all%20the%20cell%20numbers%20in%20that%20column%20and%20again%20pasted%20the%20same%20numbers%20below%20them%20in%20that%20column.%20Then%20went%20on%20to%20sort%20and%20filter%20and%20selected%20A%20to%20Z%20filter%20it%20added%20the%20rows%20in%20between.%3C%2FP%3E%3CP%3EThen%20deleted%20the%20last%20column%20and%20copy%20pasted%20the%20required%20rows%20in%20the%20original%20sheet%20it%20worked%20quite%20well%20and%20was%20very%20easy%20to%20do.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EAditya%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-104782%22%20slang%3D%22en-US%22%3ERe%3A%20Inserting%20multiple%20rows%20in%20between%20the%20existing%20data%20set%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-104782%22%20slang%3D%22en-US%22%3E%3CP%3EUse%20the%20Subtotal%20option%20from%20the%20Outline%20group%20on%20the%20Data%20Ribbon.%3C%2FP%3E%3CP%3EUse%20a%20column%20that%20has%20unique%20values.%3C%2FP%3E%3CP%3EThen%20Filter%20for%20those%20rows%20and%20Clear%20contents%20or%20edit%20as%20necessary%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-104703%22%20slang%3D%22en-US%22%3ERe%3A%20Inserting%20multiple%20rows%20in%20between%20the%20existing%20data%20set%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-104703%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Aditya%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBit%20hard%20to%20say%20without%20knowing%20of%20what%20your%20data%20is.%20As%20an%20example%2C%20you%20may%20add%20helper%20column%20to%20your%20existing%20data%20as%201%2C3%2C5%2C...%3B%20add%20at%20the%20end%20you%2017K%20of%20rows%20and%20give%20them%20index%202%2C4%2C6...%20After%20that%20sort%20all%20data%20based%20on%20this%20column.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Aditya Jadhav
Contributor

Hey

Can anyone tell me how to insert multiple alternating rows in the existing data set as some so the data needs to be sorted out and i have almost 17k rows that need to be inserted. So can anyone tell me some way of doing it quickly.

 

Regards,

Aditya

4 Replies

Hi Aditya,

 

Bit hard to say without knowing of what your data is. As an example, you may add helper column to your existing data as 1,3,5,...; add at the end you 17K of rows and give them index 2,4,6... After that sort all data based on this column. 

Use the Subtotal option from the Outline group on the Data Ribbon.

Use a column that has unique values.

Then Filter for those rows and Clear contents or edit as necessary

Hello,

I found a way to do it, i selected the rows in which i needed to add the alternate rows pasted it in another sheet, added a column gave numbers to it as 1,2,3 and autofilled it till last copied all the cell numbers in that column and again pasted the same numbers below them in that column. Then went on to sort and filter and selected A to Z filter it added the rows in between.

Then deleted the last column and copy pasted the required rows in the original sheet it worked quite well and was very easy to do.

 

Regards,

Aditya

Highlighted

Hi Aditya!

I'm just writing to say THANK YOU!!!  I've been looking for a solution to solve this problem and they all were so *complicated*!  Your solution is simple and elegant.  I am very grateful, indeed!

 

Lisannf

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies