Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re posting - Transpose employee data from Columns to Rows
Hello All,
I am using Excel 2007 and have the following problem. Following is a sample data received from our ERP in A1 Emp Code A2 - In Date B1 171091 B2 - In Time C1 Emp Name C2 - Out Date D1 Mr. Salman D2 - Out Time Column A Col B Col C Col D Employee Code : 171091 Employee Name: MR. SALMAN 13/04/11 7:28 13/04/11 18:15 14/04/11 7:37 0 0 17/04/11 7:33 17/04/11 18:15 18/04/11 7:24 18/04/11 18:03 19/04/11 7:48 19/04/11 17:43 20/04/11 7:29 20/04/11 18:19 <one blank row Employee Code : 171092 Employee Name : MR. RASHID 13/04/11 7:28 13/04/11 18:15 14/04/11 7:37 0 0 17/04/11 7:33 17/04/11 18:15 18/04/11 7:24 18/04/11 18:03 19/04/11 7:48 19/04/11 17:43 20/04/11 7:29 20/04/11 18:19 <one blank row ... .... above data repeated in the same format for several hundred rows. Each employee is separated by a blank row. Zeroes indicates not signed out I want the output to come as follows from Column G Cols G H I J K L M N O P SALMAN 13/04/11 14/04/11 17/04/11 18/04/11 19/04/11 7.28 18.15 7.37 18.15 7.33 0 7.24 18.03 7.48 18.19 RASHID <<< data for Rashid Any help would be greatly appreciated. TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transpose 4 Columns data to Rows for Employee Time In and Time Out Schedule | Excel Programming | |||
Transpose data from columns to rows | Excel Discussion (Misc queries) | |||
how to transpose a large data from columns into rows | Excel Discussion (Misc queries) | |||
transpose data between columns, rows or cells | New Users to Excel | |||
Transpose data from rows into columns | Excel Programming |