I am working with some data that needs to create duplicate rows if a cell has any number greater then 1. Here is an example; I have a column named 'Number of Rooms', if the entry is 3, I need the specific columns duplicate 3 times in new rows under the existing row.
Number of Rooms Hotel...