• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

monthly salary in "PORTRAIT" to "LANDSCAPE " model

kumartrp

New Member
Sir
We are using software generate office staff salaries in PORTRAIT moth wise
but we will prepare for an easy way to understand and finding income tax deduction verification purpose forward salary month wise per each employee wise pan based
so how to convert month wise salary data
 

Attachments

  • VERTICAL DATA FOR MONTH WISE.xls
    979 KB · Views: 16
One could use a pivot for this. See if that works for you.
 

Attachments

  • Copy of VERTICAL DATA FOR MONTH WISE.xls
    921.5 KB · Views: 26
Sir, we are prepared the same way but we were fail
Sir Your style prepared exactly suitable our vision.
it's did not got result gross salary & TDS between.
could you suggest how to get ur prepared frame sir
upload_2019-3-20_14-15-0.png
 
Seems I am using a newer Excel version (you uploaded .xls), but I believe you need to work on the layout a bit via the field areas. Try to copy as shown in the picture. "Values" should sit in Columns, below the months.
upload_2019-3-20_18-24-8.png
 
Back
Top