Auto Insert Rows

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Short answer - no.

However, they may be a way to use formulas and helper columns to pull the data to where you need it to be

It only took me less than three minutes to select blocks of cells and drag them down until the rows aligned as illustrated on Sheet2.
That said, using Ford's suggestion of helper columns, Sheet1 illustrates how the descriptions can be aligned.
1. Use formulas such as the ones in columns N:P to find the correct row number: =IF(F2<>"",IFERROR(MATCH(F2,B$1:B$19,0),SUM(N1,1)))
2. Use the following formula to get the row labels and descriptions from columns A:B in columns R:S =IF(A2<>"",A2,"")
3. Use formulas such as the ones in columns U:V, X:Y and AA:AB to get the row labels and descriptions from columns D:E, H:I and K:L =IFERROR(INDEX(E$2:E$20,MATCH(ROW(),$N$2:$N$20,0)),"")
Let us know if you have any questions.

I don't know if you want a formula solution or not. You would have to use VBA if you want to do this "in place". But if you're looking to view it like you want it, you could use formulas to do this.
The formulas here are very long, however, they have some benefits. You don't have to change the formulas as your data grows (as long as you establish the first range long enough - in this example, I'm including 1000 rows). They other columns don't even half to be in the same order - it re-orders them so they then are in the same order.

I put these on Sheet 2. For the main/first columns (A&B), I have this in cell A2:
=FILTER(Sheet1!A2:B1000,Sheet1!A2:A1000<>"")

For the second group of columns (E&F), in cell E2, enter:

Please Login or Register  to view this content.

For H&I, in cell H2, enter:

Please Login or Register  to view this content.

And for the last columns, enter this in K2:

Please Login or Register  to view this content.

See attached.