Insert new row between two existing cell in excel file

Question

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 NoName1A2B3C6F7G8H9I

Input: -

Roll NoName4D5E

Expected Output: -

Roll NoName1A2B3C4D5E7G8H9I

Emil_Kos · Answer

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!

Generate Rows.yxmd

vijaylnyadav · Answer

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 · Answer

And those values?

Roll NoName4D5E

How I should know what values should they be?