Sales for each Salesman arranged horizintally

Since you did not show what you wanted your results to look like, I assumed the following. If not what you want, then mock up what you want it to look like.

Excel 2016 (Windows) 64 bit

	G	H	I	J	K	L
2	Sum of Sales Made		Month
3	Salesman	Year	JAN	FEB	JUN	JUL
4	Ahmed Shehzad	2015			29	74
5	Anwar Ali	2015		38		29
6	Asad Shafiq	2015		55
7	Azhar Ali	2015	72	227	21	128
8	Babar Azam	2015		54	25	12
9	Fawad Alam	2015	14
10	Hammad Azam	2015		4
11	Haris Sohail	2015	51	141
12	Junaid Khan	2015	0	5
13	Mohammad Hafeez	2015	4	181	103	9
14	Mohammad Rizwan	2015	67		20	52
15	Rahat Ali	2015	1			0
16	Saad Nasim	2015	0
17	Saeed Ajmal	2015	0
18	Sarfraz Ahmed	2015	24	47		7
19	Shoaib Malik	2015		151	55	51
20	Wahab Riaz	2015	8	13
21	Yasir Shah	2015		0		1

Sheet: Batting Data

Create a pivot table as shown below

Solution for users MS Office 365 and 2021:

Please try in cell H3

Formula:

Please Login or Register  to view this content.

please try in cell G4

Formula:

Please Login or Register  to view this content.

Please try in cell H3 and copy right and down

Formula:

Please Login or Register  to view this content.