Adding separation row(s) in exported data

[Steve Marchesi]

Our team regularly exports groups of service contract data from our accounting system (TigerPaw) that requires further analysis. This data is sorted by street address. Some are single lines of the address and others are multiple lines of the same address grouped together after sorting. How can we have excel insert a row between each individual address or groups of the same address?

 

[Luke M]

Hi Steve,
Can you show us a sample of what your data looks like exactly? An uploaded workbook would be great.

Also, are you looking for a formula-only solution, or is a macro acceptable?

 

[Steve Marchesi]

Hi Luke- Uploading sample document. Highlighted column J is target column for identifying where separations need take place, but if column I, which is completely numerical data will work better, we can use that column.

Based on my audience, a formula only solution would likely be best.

Thanks,

Steve

 

[Mike H..]

Hi Luke- Uploading sample document. Highlighted column J is target column for identifying where separations need take place, but if column I, which is completely numerical data will work better, we can use that column.

Based on my audience, a formula only solution would likely be best.

Thanks,

Steve

Hi,

You can't insert rows with a formula, have a look at your workbook.

 

[Steve Marchesi]

Thanks Luke - Am I able to save this modified workbook minus the data set and import new data for future use with the embedded macro?

 

[Mike H..]

Thanks Luke - Am I able to save this modified workbook minus the data set and import new data for future use with the embedded macro?

Hi,

I assume you're responding to me. Yes you can delete the data and import new stuff and the code will work fine.

Mike.

 

[Steve Marchesi]

Thanks Luke - I figured that out in the meantime.

 

[Mike H..]

Thanks Luke

Hmmmm