• 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.

How to get/copy paste date wise horizontal employee attendance vertically

Vasimkhan25

New Member
In Row 3, I have Employee ID Col (B), Employee Name Col (C), Supervisor Name Col (D) and then in Col E to AA date wise employees attendance for 1st to 31st July.
Request your urgent help.
I have employees day wise (1st to 31st July) attendance in horizontal format, and I now want each employee's date-by-date attendance vertically. Attached is a sample excel sheet that shows how the output should be.
 

Attachments

  • Attendance_Horizontal to Vertical.xlsx
    14 KB · Views: 4

Vasimkhan25

One sample, how to - copy paste - data as You've written.
Click [ Do It ]
 

Attachments

  • Attendance_Horizontal to Vertical.xlsb
    21.2 KB · Views: 10
Cross posted to at least:
 
Last edited:

Vasimkhan25

As You've read
  • Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
  • If you do cross-post, please put that in your post.
  • Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.
from Forum Rules
which are for everyone.
 
Your I was not aware of the rules.
Could You explain with own words ... How above could be possible?
if You've cross-posted to many Forums
and
isn't it common case to study - what and how to do before the 1st posting?
 
Back
Top