Rows to columns and delete dups
Posted by Bill Adams on February 14, 2001 12:37 PM
Help !!!! I have spreadsheets where all employee information is repeated on a seperate row for each payroll account code which makes up his/her pay.
I would like to convert this to a single row of information for each employee. Everytime there is a new/different paroll account code a new column (with heading of the account code) and the amount paid should fall under each employee who has an entry for the code.
Suggestions ? (Be nice) ... hints ... help
Thanks in advance
I can also sent a workbook with before and after examples if this would help.
You can email me at firstname.lastname@example.org