Insert new row between two existing cell in excel file

[vijaylnyadav]

Hi,

Please help me i have been trying...

I was trying but instead of moving it is overwriting to the cell

I have a condition here: - 

1. Insert a new row between two existing row 

for e.g.

Consider the template output i want to insert a new row between 3 and 6 with data 4&5 as we get with the help of input.

Template Output: -     

Roll No	Name
1	A
2	B
3	C
6	F
7	G
8	H
9	I

Input: - 

Roll No	Name
4	D
5	E

Expected Output: - 

Roll No	Name
1	A
2	B
3	C
4	D
5	E
7	G
8	H
9	I

[Emil_Kos]

Hi @vijaylnyadav,

Did you try using the union tool and sorting the data by roll no afterwards?

[vijaylnyadav]

Hi @Emil_Kos but here output is not getting into our workflow.

I cant use output data in our workflow i just want to insert between two rows without overwriting it. Instead moving the last cell downwards and insert to the newly created row.

[Emil_Kos]

And those values?

Roll No	Name
4	D
5	E

How I should know what values should they be? 

[vijaylnyadav]

hi @Emil_Kos we only know the cell number where it should be inserted. in this case we have to insert into cell number 5 and move all the existing data downwards

[Emil_Kos]

Hi @vijaylnyadav,

This should work for you:

Thank to generate rows tool, we generate rows based on the maximum number of roll no. 

After that, we are joining it with the data and we identify each position that we are missing.

I kept the name blank as I didn't know what information you want to insert there:

Good luck!