Re posting - Transpose employee data from Columns to Rows

N

Nasir

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 RashidAny help would be greatly appreciated.
TIA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top