Newer Excel user with some experience, but this is out of my realm of knowledge.

I have a simple table (INPUT) that I want to be able to generate a new table (OUTPUT) based on the value of Column C (Quantity).
For example. My INPUT table has a row of Material A with a qty of 3. I want to automatically generate the OUTPUT table to have three rows with the material information copied to each row, and a value of one. I need the OUTPUT table to have as many rows as defined in Column C of the INPUT table if that makes sense. See my example in the attached sheet. The INPUT table is my source data, and the OUTPUT table is my desired resulting table. Any ideas how to manage this? I often have INPUT tables of 4-100 lines all with varying QTYs listed in Columns C, and manually splitting them is a pain! Thanks in advance!!
5000326 QTY 10 SAMPLE.xlsx