Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Payroll | Excel Discussion (Misc queries) | |||
Adding payroll stubs payroll calculator | New Users to Excel | |||
Enable transfer of payroll data from Quickbooks | Setting up and Configuration of Excel | |||
I need a form to create pay stubs from a payroll data sheet | Excel Discussion (Misc queries) | |||
How do I keep each week's data from the payroll calcualtor? | Excel Worksheet Functions |