Can some one help in transposing data from multiple columns to selected columns while maintaining column properties with the following conditions:
1. Employee ID - in Text format
2. Record # - in Text Format
3. Date Worked - in Date "mm/dd/yyyy" Format
4. TRC - in Text Format
5. Hours Worked - in Number (2 decimal places) Format
6. Over Ride Rate - in Number (3 decimal places) Format
7. Accounting Code - in Text format
8. Pay Period Ending Date - User Defined or linked to Source worksheet cell # (Y1+14 days)
Sample file is attached with desired data in "output" worksheet.
Thanks
Ravi
Bookmarks