Payroll data
 

Hi Reena,
Hard to tell what you actually have in Excel, but since it is your
problem, please take a look at
Snake columns
http://www.mvps.org/dmcritchie/excel/snakecol.htm
and see if you can solve your problem, yourself.

If not then then indicate what cells are populated,
my guess would be A1, B1, A2, B3

On another sheet
A1: =OFFSET(Sheet17!$A$1,ROW()*3-3,0)
B1: =OFFSET(Sheet17!$A$1,ROW()*3-3,1)
C1: =OFFSET(Sheet17!$A$1,ROW()*3-2,0)
D1: =OFFSET(Sheet17!$A$1,ROW()*3-2,1)
E1: =OFFSET(Sheet17!$A$1,ROW()*3-1,0)
F1: =OFFSET(Sheet17!$A$1,ROW()*3-1,1)

then use the fill handle and copy down, results like this

A1 B1 A2 B2 A3 B3
A4 B4 B4 B4 B4 A4
A7 B7 B7 B7 B7 A7
A10 B10 B10 B10 B10 B10
A13 B13 B13 B13 B13 A13
A16 B16 B16 B16 B16 A16

Then select the sheet and copy Ctrl+C
Edit, paste special, Values

Eliminate the unwanted column which I think is E, if it
is empty.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"reena" wrote in message ...
hi guys

I have payroll data exported to excel. data format is
as follows


Emploree Numnber Employee Name

Basic salary

deductions


Net Amount Paid "1000"



I want to get this in a tabular format.i.e employee number
and net amount paid in one row

How can i do it
any Help greatly appreciated

Thanks
Reena