Duty List from Data in Excel

[awanak]

I have data of employees who are deputed on examination duties across country. the data is as under:

Statement of Staff Phase-I_II-2021 after Meeting.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L
1	S.No	Name	Designation	Place of Posting	Duty	Centre	Name of Hall	From	To	No. of Days	Previous Duty Local	Previous Duty (Outstation)
2	1	Mr. Aamir	Director	IT	Supervisor	Gilgit-1	Fatima Jinnah Govt. Gilgit.	01-10-2021	10-10-2021	11	10	12
3	2	Mr. Akram	Assistant	T&S	Dy. Supervisor/ Invigilator	Gilgit-1	Fatima Jinnah Govt. Gilgit.	01-10-2021	10-10-2021	11	8	15
4	3	Mr. Saleem Noor	Assitant Director	HR	Supervisor	Lahore-1	Mustafa Town, Wahdat Road, Lahore.	05-10-2021	10-10-2021	7	13	11
5	4	Mr. Mohsin Dar	Deputy Director	Admn	Invigilator/ Clerk	Islamabad-2	IMCG, G-6/1, Islamabad	04-10-2021	14-10-2021	12	9	13
6	5	Mr. Kamal Ahsan	Naib Qasid	Secrecy	Daftry	Gilgit-1	Fatima Jinnah Govt. Gilgit.	01-10-2021	10-10-2021	11	10	9
7	6	Ms. Sobia Khalid	LDC	T&S	Invigilator/ Clerk	Lahore-1	Mustafa Town, Wahdat Road, Lahore.	05-10-2021	10-10-2021	7	15	17
8	7	Mr. Unsar Ali Awan	UDC	Legal	Supervisor	Islamabad-2	IMCG, G-6/1, Islamabad	04-10-2021	14-10-2021	12	11	11
9	8	Mr. Murtaza	Naib Qasid	HR	Daftry	Islamabad-2	IMCG, G-6/1, Islamabad	04-10-2021	14-10-2021	12	13	19
10	9	Mr. Wajid Murtaza	Qasid	CE	Daftry	Lahore-1	Mustafa Town, Wahdat Road, Lahore.	05-10-2021	10-10-2021	7	8	20
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E1:J1	Cell Value	="No Duty"	text	NO
J2:L10,K1:L1,E2:G10	Cell Value	="No Duty"	text	NO

I want to have output automatically to be as under:

Statement of Staff Phase-I_II-2021 after Meeting.xlsm
	A	B	C	D
1	Hall-1 (Gilgit)
2	Fatima Jinnah Govt. Degree College for Women, Chinnar Bagh, Gilgit.
3	Dates 01-10-2021 to 10-10-2021			Previous Duty (Outstation)
4
5	S.No.	Description	Name & Designation
6	1	Supervisor	Mr. Aaamir, Director (IT)	12
7	2	Dy. Supervisor/ Invigilator	Mr. Akram, Assistant (T&S)	15
8	3	Daftry	Mr. Kamal Ahsan, Naib Qasid (Secrecy)	9
Sheet5

 

[Fluff]

Duplicate to: Creation of Duty List

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.