Excel - List out all the numbers within a given range

[klitton7]

I need a way to list all the numbers between each range of numbers in columns H and I.
It would also be great to have the associated information in the other columns appear with each entry (or at least column D)

Thank you!

 

[klitton7]

Thank you very much - I am anxious to start learning how to use this powerful tool.

 

[alansidman]

Here is the revised file

Sage - Format Groups.xlsx | Powered by Box

app.box.com

I would suggest you pick up a book

Master Your Data with Power Query in Excel and Power BI

Despite the moniker "data monkey," we information workers are often more like data magicians. Our data seldom enters our world in a ready-to-consume format; it can take hours of cleaning, filtering, and reshaping to get things ready to go. Power Query will make this process faster the first time...

www.mrexcel.com

 

[klitton7]

Thanks alansidman - I will check out the book.
Thanks for sending 11 & 12!
Merry Christmas - God bless you and your family!

 

[alansidman]

You are welcome. Happy Holidays to you also.