Trick 012 Create a character list in a distance for before with power query

 The problem is. we have to create an ordered list from a given interval.

  Take for example a building with multiple floors. Each floor has many rooms. Each floor has different first room number and the quantity of rooms in that floor is also different.

  So how do we get the entire list of room numbers of the floors in that building.

  With this example I will show you how to solve this problem with power query.

Link to download excel file.