User Input data verticaly but we required in row wise

[shantaramc]

hi

i am working of automation for attendance i am attached herewith excel sheet of attendance in which user will input attendance data in "Att. Aut-19" Sheet , we required data as per sheet1 for analysis ,

1- ADMIN STAFF-	Day:	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Total Presents
Sr. No.	Name		Father Name	Designation	Date of Joining	Date:	01	02	03	04	05	06	07	08	09	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31
1	Shantaram	S/O	Chopade	Op Manager			P	W	P	H																												31

out put sheet

Employee Name	Date	Open time	Closing time
Shantaram	12/01/19​	9:30​	6:30 PM​
Shantaram	12/03/19​	9:30​	6:30 PM​
Shantaram	12/04/19​	9:30​	1:30 PM​

please help.

 

[My Aswer Is This]

Sorry to see you have not received a answer. I looked at this post several days ago and did not understand it. So maybe others here thought the same.

It would be nice if you explained in written detail what you want.

And we need column numbers like column A or B

Looking at your image we have no way of knowing what columns we are dealing with here
For example on your output sheet you want opening time and closing time.
But I see nothing on original sheet showing those times.

 

[My Aswer Is This]

Let me know if you understand my questions