Macro to Create Individual Records from List with Qtys

I receive data from a customer such as in file "Applied Data.xls"
Column A is Quantity. Column B is data.

I need to run this data through software that only accepts individual records. For example Qty 15 of Data 9929 in first line of file must show "9929" listed 15 times to print correctly.

2nd attachment shows the resulting .csv file that I need with example data & quantities. Cells A1, "Applied1" and A2 "txtField1" must remain UNCHANGED and always be present.
Can a macro be written to take data from "Applied Data.xls" and create a new file looking like "Applied1.csv"

It must work with any number of records. For example, there may be dozens of data records with multiple Qtys required of each.
If not a macro, then what? Open to suggestions