Add new lines according to value in the spreadsheet

[Arthurico]

Hi,

I have a spread sheet with table (which for some reason I can't attach), but it has 4 columns - 2 descriptive (let's call those Sub Account and Sub Account 2) and a range (From, To) which contain values. I want in the cases where To>From to add a relevant number of new lines, until From=to. In the below example (table 1) I would like to create (table 2).

Sub Account Sub Account 2 From To
AD AD 15000520 15000523

Sub Account Sub Account 2 From To
AD AD 15000520 15000520
AD AD 15000521 15000521
AD AD 15000522 15000522
AD AD 15000523 15000523

HELPPPPPPPPPPPPPP

[alansidman]

To attach a sample file--->

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Arthurico]

Hi,

I attached the file, can you help with the solution...?

[JeteMc]

This proposal employs four helper columns which may be moved and/or hidden for aesthetic purposes.
The first helper column (E) is populated using: =D2-C2+1
The first cell of the second helper column (F) is populated by the number one and the rest of the column is populated using: =SUM(F1,E2)
The third and fourth helper columns (G:H) are populated using:

Please Login or Register  to view this content.

The Sub Account and Sub Account 2 columns (J:K) for the new table are populated using:

Please Login or Register  to view this content.

The From column (L) for the new table is populated using:

Please Login or Register  to view this content.

The To column (M) for the new table is populated using: =L2
Note that I only filled the formulas down as far as row 620. Once you have enabled editing of the file you will need to pull the formulas in columns G:H and J:M down to row 1380 as indicated by the value in cell F618.
Let us know if you have any questions.

[Arthurico]

this proposal employs four helper columns which may be moved and/or hidden for aesthetic purposes.
The first helper column (e) is populated using: =d2-c2+1
the first cell of the second helper column (f) is populated by the number one and the rest of the column is populated using: =sum(f1,e2)
the third and fourth helper columns (g:h) are populated using:

Please Login or Register  to view this content.

the sub account and sub account 2 columns (j:k) for the new table are populated using:

Please Login or Register  to view this content.

the from column (l) for the new table is populated using:

Please Login or Register  to view this content.

the to column (m) for the new table is populated using: =l2
note that i only filled the formulas down as far as row 620. Once you have enabled editing of the file you will need to pull the formulas in columns g:h and j:m down to row 1380 as indicated by the value in cell f618.
Let us know if you have any questions.

amazing!!!! Thank you soooooooooo much!!!

[JeteMc]

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools drop down in the ribbon above your first post. I hope that you have a blessed day.