Inserting Rows Based On 8 Rows Per Mile in a Data Set

Hello community

I was hoping someone could help me with a very difficult problem which I just cannot over come.

I am given a report, which contains data in column A B C.

The data in these columns represent distance along the highway.

Column A represents the Start of the Road in Miles.

Column B represents the Start of a section of road in Yards.

Column C represents the End of a section of road in Yards.

So 29 0 220 would the road section 29Miles 0Yards to 220Yards

The data should be presented such that each mile in the report should be composed of exactly 8 rows in whole yards, where each row represents 220yards of road for example:-

Aa.JPG

The problem is that the data is never presented in such a way, often it is presented in the following way:-

Bb.JPG

As you can see 30 mile only has 1 row which is just 22 yards and 31 mile Help.xls4 rows associated with it.

I need to format the data such that if there are less then 8 rows representing a mile then the start row of the mile is copied until there are 8 rows for that mile for example:-

Cc.JPG

As you can see the green cells are the inserted rows to make up 8 rows per mile.

Is there anyone out there who can help me I have been struggling with this for so long that I am going crazy.

I cannot seem to upload my raw my email is unomo@hotmail.com I can email it to you.

Thanks

Hi Mark-
1) What are your columns?
2) What is your first row of data?
3) What is your last row of data?
4) Are there any blank rows within the data?
5) Are there any missing mile numbers, or is it a complete sequence?

Try

Please Login or Register  to view this content.

Kind regards
Leo

Try this:-
Your actual data assumed to start "A2".
Result start "E1".

Please Login or Register  to view this content.

Regards Mick