I have a spreadsheet with several thousand rows of summary data, and
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

--
hvibberts2
-----------------------------------------------------------------------
hvibberts25's Profile: http://www.excelforum.com/member.php...fo&userid=2593
View this thread: http://www.excelforum.com/showthread.php?threadid=39302