I have a spreadsheet that lists medical equipment (identified by JSN) within a room. A single piece of equipment (JSN) may have multiple quantities within a room. I'd like to separate all rows that have a quantity greater than 1 into multiple rows with the same data while simultaneously changing the quantity to 1 EA. Here is an example of what the existing spreadsheet looks like (minus other columns):
Nomenclature JSN Wayfinding Rm # QTY Installed
Shelving, Solid M2090 40-179 3 5/5/15
Waste Can, Swing F2010 11-087 2 9/9/15
Stand, Mayo, Screw M8810 11-078 1 8/1/15
Here is what I would need it to look like:
Nomenclature JSN Wayfinding Rm # QTY Installed
Shelving, Solid M2090 40-179 1 5/5/15
Shelving, Solid M2090 40-179 1 5/5/15
Shelving, Solid M2090 40-179 1 5/5/15
Waste Can, Swing F2010 11-087 1 9/9/15
Waste Can, Swing F2010 11-087 1 9/9/15
Stand, Mayo, Screw M8810 11-078 1 8/1/15
Any help would be greatly appreciate. Please make note that I just found out about VBAs and Macros TODAY! Trying to learn. Thank you so much to anyone that can assist this struggling but eager novice!