I have a spreadsheet with several thousand rows of summary data, and I need to expand that data so i have one row for each person...

for example I have the following where the column headers are
Number of Employees Gender Annual Salary Age

and the corresponding data is
148 M 38201 52

I need 148 rows of
M 38201 52

any ideas?