Data Formatting

[aazimyousuf]

Need help regarding how I can copy the data from different columns having some cells with no data into a single column ignoring the empty cells.

Temperature 1981-2016.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N
107		jan	feb	mar	apr	may	jun	jul	aug	sep	oct	nov	dec
108	1	11.1	13.5	14.3	14.9	20.1	30.6	24.8	28	29	24.8	17.9	14.1
109	2	10.7	7.1	13.7	9.4	22.8	31.5	28.3	27.7	22.9	25.5	19.4	12.8
110	3	10.7	4.9	15.6	17.2	25.8	32.5	26	29.5	27	20.7	21.5	14.1
111	4	11.4	4.2	16.9	15.8	27.6	30.4	30.1	33.1	26.5	22.2	20.3	14.4
112	5	0	3.9	17.4	13.3	27	28.7	30	32.4	29.6	24.6	19.8	13.9
113	6	5.4	7.8	16.1	17.5	27.7	28.4	31.6	31	29.1	25.5	18.5	10.5
114	7	7.5	4.1	17.1	0	29.4	29.6	28.6	29.7	22.1	24.8	17.7	12.8
115	8	6.2	5.7	17.8	14.3	22.3	31.8	28.7	32.3	19.4	24.8	15.5	11.1
116	9	4.5	3.9	16.2	9.8	23.7	32.2	26.8	30.4	20.2	24	13.4	13.1
117	10	8.9	13.5	18.4	16.9	24.1	31.8	19.1	31.6	24.5	22.9	13.7	9.4
118	11	8.2	7.1	19.2	18.3	24.3	24.9	26.8	30.9	27.7	24.5	14.5	5.7
119	12	4.5	4.9	17.3	21.5	21.6	24.8	27.3	27.5	29.2	25.8	15.7	10.5
120	13	5.8	4.2	17.3	23.1	23.3	28.8	27.5	30.6	29.2	25.1	12.4	9
121	14	9.3	3.9	15.5	23.9	25.5	31.1	28.4	26.8	28.3	24.5	15.6	4.5
122	15	5.4	7.8	14.5	23.5	21.9	31.6	31.2	29.5	22.7	26.7	14.6	10.6
123	16	5.7	4.1	14.4	23.2	14.5	33.3	29.2	31.3	27.7	24	12.5	10.7
124	17	7.1	5.7	14.2	19.7	21.5	32.3	30.2	27.7	28.9	26.4	13.9	10.5
125	18	2.5	3.9	9.6	21	25	26.2	27.3	29.9	29.3	26.7	15.3	7.5
126	19	4	2.4	13.7	20.5	26.7	26.7	29.4	31.4	23.2	27.1	13.9	8.7
127	20	9.2	3.5	14.2	19.1	25.1	29.5	28.3	30.2	24.2	27.7	10.7	8.8
128	21	7.3	7.5	16.3	0	22.7	28.9	28.3	29.7	24.4	27.1	5.9	9.7
129	22	7.7	8.5	19.5	13.9	27.6	30.6	26.2	31.7	25.1	23.3	4.4	8
130	23	8.8	9	20.9	19.9	28.2	30.8	30.3	31.7	25.1	23.4	7.9	10.1
131	24	8.4	7.1	22.9	24.2	30.7	31.6	29.8	29.6	22.3	22.8	10.6	10.4
132	25	7.3	9.7	22.8	26.3	31.7	32.2	28.5	30.4	23.6	22.7	11.1	8.6
133	26	7.8	2.7	0	24.7	32.8	31.8	30.5	28.7	25.5	21.5	11.9	4.9
134	27	11.7	3.9	17.9	25.8	29.5	30.4	30.5	30.2	23.4	17.7	12.2	7.7
135	28	10.7	3.9	20.4	21.5	31.3	29.1	29.3	27.6	23.5	17.4	13.4	2
136	29	11.1		23.4	19.7	23.7	25.1	29.3	21.9	23.5	17.2	13.4	7.6
137	30	11.3		22.1	18.8	23.3	25.1	28.3	29.4	23.5	26.4	13.4	6.9
138	31	11.3		22.6		28		28.3	30.4		26.7		1.9
Qazigund_maxtemp

 

[Peter_SSs]

Welcome to the MrExcel board!

So, what would the results (or at least part of them) look like for that sample data and where would those results be located (another XL2BB perhaps)?

 

[aazimyousuf]

Welcome to the MrExcel board!

So, what would the results (or at least part of them) look like for that sample data and where would those results be located (another XL2BB perhaps)?

please clarify i did not got it

 

[Peter_SSs]

please clarify i did not got it

From what I can see have given some sample data and asked a question about it. I am not certain what you want or where you want it so I am asking you to manually prepare the result(s) that you want and show that to us.

 

[aazimyousuf]

I need to format the data like the one provided in the sheet attached

temp.xlsx
	A	B
2	DATE	max
3	1/1/1981	10.5
4	1/2/1981	9.8
5	1/3/1981	9
6	1/4/1981	1.5
7	1/5/1981	2.8
8	1/6/1981	4.2
9	1/7/1981	7.7
10	1/8/1981	8.8
11	1/9/1981	6.9
12	1/10/1981	6.7
13	1/11/1981	7.2
14	1/12/1981	7.7
15	1/13/1981	8
16	1/14/1981	8.3
17	1/15/1981	8.5
18	1/16/1981	7.7
19	1/17/1981	9.7
20	1/18/1981	11.7
21	1/19/1981	9.3
22	1/20/1981	9.3
23	1/21/1981	8.7
24	1/22/1981	3.7
25	1/23/1981	4.5
26	1/24/1981	5.3
27	1/25/1981	4.5
28	1/26/1981	6.5
29	1/27/1981	5.9
30	1/28/1981	2.1
31	1/29/1981	6.5
32	1/30/1981	5.9
33	1/31/1981	2.1
34	2/1/1981	1.9
35	2/2/1981	4.9
36	2/3/1981	6
37	2/4/1981	5.3
38	2/5/1981	2.7
39	2/6/1981	3.7
40	2/7/1981	9.5
41	2/8/1981	6.3
42	2/9/1981	6.4
43	2/10/1981	8.1
44	2/11/1981	6.8
45	2/12/1981	10
46	2/13/1981	9.4
47	2/14/1981	10.7
48	2/15/1981	6.2
49	2/16/1981	8.3
50	2/17/1981	11
51	2/18/1981	11.3
52	2/19/1981	12.7
53	2/20/1981	13.4
54	2/21/1981	12.5
55	2/22/1981	13.5
56	2/23/1981	11.1
57	2/24/1981	9
58	2/25/1981	10.7
59	2/26/1981	10.3
60	2/27/1981	10.3
61	2/28/1981	10.3
62	3/1/1981	11.6
63	3/2/1981	11.8
64	3/3/1981	11.3
65	3/4/1981	11.3
66	3/5/1981	11.6
67	3/6/1981	11.8
68	3/7/1981	11.3
69	3/8/1981	8.8
70	3/9/1981	6.4
71	3/10/1981	10.5
72	3/11/1981	8.9
73	3/12/1981	5.6
74	3/13/1981	9.9
75	3/14/1981	11.9
76	3/15/1981	13.7
77	3/16/1981	10.2
78	3/17/1981	16.4
79	3/18/1981	17.7
80	3/19/1981	15.3
81	3/20/1981	19.7
82	3/21/1981	19.7
83	3/22/1981	14.3
84	3/23/1981	17.7
85	3/24/1981	19.4
86	3/25/1981	19.4
87	3/26/1981	19.9
88	3/27/1981	20.3
89	3/28/1981	19.9
90	3/29/1981	19.9
91	3/30/1981	3.4
92	3/31/1981	3.4
93	4/1/1981	8.9
94	4/2/1981	14.9
95	4/3/1981	14.3
96	4/4/1981	10.4
97	4/5/1981	17.3
98	4/6/1981	17.4
99	4/7/1981	17.8
100	4/8/1981	16.6
101	4/9/1981	20.3
102	4/10/1981	22.4
103	4/11/1981	23.5
104	4/12/1981	25.1
105	4/13/1981	25.9
106	4/14/1981	26.2
107	4/15/1981	26.5
108	4/16/1981	26.5
109	4/17/1981	21.8
110	4/18/1981	24.5
111	4/19/1981	26.3
112	4/20/1981	26.5
113	4/21/1981	19.5
114	4/22/1981	16.2
115	4/23/1981	20.7
116	4/24/1981	23.4
117	4/25/1981	25.1
118	4/26/1981	25.8
119	4/27/1981	22.8
120	4/28/1981	21.3
121	4/29/1981	16.7
122	4/30/1981	16.7
123	5/1/1981	21.2
124	5/2/1981	25.3
125	5/3/1981	27.8
126	5/4/1981	29.5
127	5/5/1981	27.7
128	5/6/1981	21
129	5/7/1981	17.1
130	5/8/1981	21.5
131	5/9/1981	23
132	5/10/1981	24.3
133	5/11/1981	19.5
134	5/12/1981	23.9
135	5/13/1981	27
136	5/14/1981	27.2
137	5/15/1981	24.4
138	5/16/1981	24.3
139	5/17/1981	27.4
140	5/18/1981	29.3
141	5/19/1981	27.6
142	5/20/1981	22
143	5/21/1981	22
144	5/22/1981	25.1
145	5/23/1981	28.8
146	5/24/1981	29.3
147	5/25/1981	31.5
148	5/26/1981	28.2
149	5/27/1981	27.7
150	5/28/1981	27.9
151	5/29/1981	27.9
152	5/30/1981	27.9
153	5/31/1981	27.9
154	6/1/1981	20.4
155	6/2/1981	19.5
156	6/3/1981	19.5
157	6/4/1981	21.6
158	6/5/1981	22.8
159	6/6/1981	22.8
160	6/7/1981	22.8
161	6/8/1981	22.8
162	6/9/1981	21.3
163	6/10/1981	19.3
164	6/11/1981	21.7
165	6/12/1981	22.7
166	6/13/1981	25.3
167	6/14/1981	26.1
168	6/15/1981	27.3
169	6/16/1981	28.7
170	6/17/1981	29.3
171	6/18/1981	29.7
172	6/19/1981	30.5
173	6/20/1981	30.5
174	6/21/1981	28.2
175	6/22/1981	27.6
176	6/23/1981	28.3
177	6/24/1981	29.7
178	6/25/1981	29.2
179	6/26/1981	30.3
180	6/27/1981	32.3
181	6/28/1981	31.5
182	6/29/1981	33.7
183	6/30/1981	33.7
184	7/1/1981	27.4
185	7/2/1981	26.1
186	7/3/1981	29.5
187	7/4/1981	28.8
188	7/5/1981	25.9
189	7/6/1981	24.7
190	7/7/1981	26.7
191	7/8/1981	28
192	7/9/1981	29.9
193	7/10/1981	23.4
194	7/11/1981	24
195	7/12/1981	29.7
196	7/13/1981	31.9
197	7/14/1981	31.6
198	7/15/1981	29.5
199	7/16/1981	27.2
200	7/17/1981	27.7
201	7/18/1981	29.6
202	7/19/1981	28.3
203	7/20/1981	31
204	7/21/1981	31.3
205	7/22/1981	28
206	7/23/1981	26.5
207	7/24/1981	27.3
208	7/25/1981	24.4
209	7/26/1981	20.5
210	7/27/1981	27.1
211	7/28/1981	29.6
212	7/29/1981	27.9
213	7/30/1981	26.9
214	7/31/1981	24.4
215	8/1/1981	26.4
216	8/2/1981	28.5
217	8/3/1981	29.7
218	8/4/1981	28.1
219	8/5/1981	29
220	8/6/1981	28.2
221	8/7/1981	29.8
222	8/8/1981	29.5
223	8/9/1981	25.2
224	8/10/1981	29.7
225	8/11/1981	28.7
226	8/12/1981	30
227	8/13/1981	29.8
228	8/14/1981	28.3
229	8/15/1981	27.5
230	8/16/1981	27.7
231	8/17/1981	28.6
232	8/18/1981	30.7
233	8/19/1981	31.2
234	8/20/1981	28.7
235	8/21/1981	22
236	8/22/1981	26.8
237	8/23/1981	28.8
238	8/24/1981	30.2
239	8/25/1981	26.9
240	8/26/1981	23.7
241	8/27/1981	28
242	8/28/1981	28.2
243	8/29/1981	29.8
244	8/30/1981	25.2
245	8/31/1981	29.5
246	9/1/1981	29.1
247	9/2/1981	29.5
248	9/3/1981	28.2
249	9/4/1981	22.9
250	9/5/1981	28.1
251	9/6/1981	21.6
252	9/7/1981	27.9
253	9/8/1981	25.2
254	9/9/1981	28.1
255	9/10/1981	27.3
256	9/11/1981	23.4
257	9/12/1981	24
258	9/13/1981	26.3
259	9/14/1981	28.5
260	9/15/1981	28.9
261	9/16/1981	28.2
262	9/17/1981	28.3
263	9/18/1981	27.7
264	9/19/1981	21.9
265	9/20/1981	24.8
266	9/21/1981	26.5
267	9/22/1981	23.4
268	9/23/1981	28.2
269	9/24/1981	29.6
270	9/25/1981	28.4
271	9/26/1981	29.9
272	9/27/1981	28.3
273	9/28/1981	27.2
274	9/29/1981	27.6
275	9/30/1981	24.3
276	10/1/1981	25.7
277	10/2/1981	26.2
278	10/3/1981	24.7
279	10/4/1981	24.8
280	10/5/1981	24.7
281	10/6/1981	24.7
282	10/7/1981	21.5
283	10/8/1981	20.7
284	10/9/1981	16.7
285	10/10/1981	21.8
286	10/11/1981	23.3
287	10/12/1981	25
288	10/13/1981	25.7
289	10/14/1981	26.2
290	10/15/1981	24.7
291	10/16/1981	24.8
292	10/17/1981	24.7
293	10/18/1981	24.7
294	10/19/1981	21.2
295	10/20/1981	22.3
296	10/21/1981	20
297	10/22/1981	21.8
298	10/23/1981	23.3
299	10/24/1981	23.8
300	10/25/1981	23.9
301	10/26/1981	23.8
302	10/27/1981	23.3
303	10/28/1981	20.5
304	10/29/1981	22.5
305	10/30/1981	17.7
306	10/31/1981	17.2
307	11/1/1981	19.4
308	11/2/1981	20.2
309	11/3/1981	19.9
310	11/4/1981	19.9
311	11/5/1981	14.6
312	11/6/1981	16.8
313	11/7/1981	18
314	11/8/1981	18.5
315	11/9/1981	17.9
316	11/10/1981	18.3
317	11/11/1981	16.9
318	11/12/1981	9.5
319	11/13/1981	15.3
320	11/14/1981	16.3
321	11/15/1981	17.6
322	11/16/1981	17.9
323	11/17/1981	18.1
324	11/18/1981	17.2
325	11/19/1981	16.9
326	11/20/1981	16.4
327	11/21/1981	16.5
328	11/22/1981	16.2
329	11/23/1981	15.8
330	11/24/1981	16
331	11/25/1981	17.6
332	11/26/1981	13
333	11/27/1981	13.9
334	11/28/1981	10.7
335	11/29/1981	14.5
336	11/30/1981	14.8
337	12/1/1981	9.9
338	12/2/1981	11.2
339	12/3/1981	9.8
340	12/4/1981	11
341	12/5/1981	11
342	12/6/1981	12.1
343	12/7/1981	12.4
344	12/8/1981	12.1
345	12/9/1981	12.3
346	12/10/1981	11.4
347	12/11/1981	10.9
348	12/12/1981	10.7
349	12/13/1981	11.2
350	12/14/1981	10.5
351	12/15/1981	10.5
352	12/16/1981	10.5
353	12/17/1981	11.5
354	12/18/1981	11.3
355	12/19/1981	11.4
356	12/20/1981	11.2
357	12/21/1981	10.1
358	12/22/1981	8.4
359	12/23/1981	4.9
360	12/24/1981	7
361	12/25/1981	9.5
362	12/26/1981	9.8
363	12/27/1981	10.7
364	12/28/1981	11.2
365	12/29/1981	10.5
366	12/30/1981	10.5
367	12/31/1981	10.5
368	1/1/1982	8.7
369	1/2/1982	10.1
370	1/3/1982	12.5
371	1/4/1982	14.5
372	1/5/1982	6.7
373	1/6/1982	7.6
374	1/7/1982	9.6
375	1/8/1982	7.9
376	1/9/1982	7.8
377	1/10/1982	5.5
378	1/11/1982	5.7
379	1/12/1982	9.9
380	1/13/1982	11
381	1/14/1982	11
382	1/15/1982	12.4
383	1/16/1982	12.3
384	1/17/1982	12
385	1/18/1982	11.8
386	1/19/1982	8.5
387	1/20/1982	12.9
388	1/21/1982	12.5
389	1/22/1982	10.8
390	1/23/1982	4.2
391	1/24/1982	4.7
392	1/25/1982	3.9
393	1/26/1982	1.4
394	1/27/1982	6.2
395	1/28/1982	3
396	1/29/1982	5.9
397	1/30/1982	2.4
398	1/31/1982	4.8
399	2/1/1982	9
400	2/2/1982	5.9
401	2/3/1982	3.6
402	2/4/1982	8.1
403	2/5/1982	8
404	2/6/1982	7.4
405	2/7/1982	4
406	2/8/1982	7.3
407	2/9/1982	2.3
408	2/10/1982	0.8
409	2/11/1982	2.7
410	2/12/1982	4.9
411	2/13/1982	11.2
412	2/14/1982	11.2
413	2/15/1982	5.1
414	2/16/1982	8.5
415	2/17/1982	5.3
416	2/18/1982	9.1
417	2/19/1982	4.9
418	2/20/1982	7.3
419	2/21/1982	0.7
420	2/22/1982	0.7
421	2/23/1982	3.7
422	2/24/1982	5.2
423	2/25/1982	6.4
424	2/26/1982	8.6
425	2/27/1982	5.3
426	2/28/1982	1.8
427	3/1/1982	5.7
428	3/2/1982	8.3
429	3/3/1982	9.9
430	3/4/1982	5.1
431	3/5/1982	2.6
432	3/6/1982	6.7
433	3/7/1982	10.5
434	3/8/1982	10.5
435	3/9/1982	10.4
436	3/10/1982	3.9
437	3/11/1982	8.2
438	3/12/1982	8.8
439	3/13/1982	12.6
440	3/14/1982	13.5
441	3/15/1982	15.7
442	3/16/1982	8.7
443	3/17/1982	10.7
444	3/18/1982	13.7
445	3/19/1982	15.7
446	3/20/1982	13.3
447	3/21/1982	10.5
448	3/22/1982	9.8
449	3/23/1982	3.5
450	3/24/1982	4.3
451	3/25/1982	10.5
452	3/26/1982	14.4
453	3/27/1982	16.8
454	3/28/1982	15.7
455	3/29/1982	18.7
456	3/30/1982	16.3
457	3/31/1982	20.5
458	4/1/1982	20.4
459	4/2/1982	22
460	4/3/1982	23.4
461	4/4/1982	18.9
462	4/5/1982	18.9
463	4/6/1982	14.5
464	4/7/1982	16.5
465	4/8/1982	20.1
466	4/9/1982	21.7
467	4/10/1982	21.9
468	4/11/1982	21.3
469	4/12/1982	22.2
470	4/13/1982	23.7
471	4/14/1982	24.3
472	4/15/1982	24.3
473	4/16/1982	16.7
474	4/17/1982	8.9
475	4/18/1982	13.9
476	4/19/1982	18.3
477	4/20/1982	22.1
478	4/21/1982	23.3
479	4/22/1982	24.1
480	4/23/1982	25.7
481	4/24/1982	24.3
482	4/25/1982	20.3
483	4/26/1982	14.9
484	4/27/1982	19.5
485	4/28/1982	19.5
486	4/29/1982	17.7
487	4/30/1982	21.8
488	5/1/1982	25.3
489	5/2/1982	25.8
490	5/3/1982	24.2
491	5/4/1982	26.8
492	5/5/1982	28
493	5/6/1982	26.8
494	5/7/1982	21.8
495	5/8/1982	23.5
496	5/9/1982	23.1
497	5/10/1982	22.3
498	5/11/1982	18.8
499	5/12/1982	12.4
500	5/13/1982	11.3
501	5/14/1982	16.7
502	5/15/1982	16.9
503	5/16/1982	19.4
504	5/17/1982	22.7
505	5/18/1982	24.2
506	5/19/1982	23.7
507	5/20/1982	20.8
508	5/21/1982	24.5
509	5/22/1982	26.3
510	5/23/1982	24.4
511	5/24/1982	23.7
512	5/25/1982	26.7
513	5/26/1982	27.3
514	5/27/1982	22.5
515	5/28/1982	21.9
516	5/29/1982	25.9
517	5/30/1982	25.9
518	5/31/1982	20.2
519	6/1/1982	21.1
520	6/2/1982	23.3
521	6/3/1982	26.8
522	6/4/1982	28.5
523	6/5/1982	29.8
524	6/6/1982	30.8
525	6/7/1982	31.9
526	6/8/1982	31.7
527	6/9/1982	31.7
528	6/10/1982	32.3
529	6/11/1982	29.7
530	6/12/1982	29.6
531	6/13/1982	31.3
532	6/14/1982	32.7
533	6/15/1982	24
534	6/16/1982	26.9
535	6/17/1982	25.5
536	6/18/1982	21.6
537	6/19/1982	24.3
538	6/20/1982	27.9
539	6/21/1982	27.6
540	6/22/1982	24.7
541	6/23/1982	25.2
542	6/24/1982	24.5
543	6/25/1982	27.1
544	6/26/1982	29.1
545	6/27/1982	26
546	6/28/1982	27.6
547	6/29/1982	29.7
548	6/30/1982	27.5
549	7/1/1982	25.6
550	7/2/1982	29
551	7/3/1982	28.6
552	7/4/1982	27.5
553	7/5/1982	26.9
554	7/6/1982	21.8
555	7/7/1982	26.8
556	7/8/1982	27.9
557	7/9/1982	29.8
558	7/10/1982	22.6
559	7/11/1982	26.5
560	7/12/1982	27.7
561	7/13/1982	29.4
562	7/14/1982	31.2
563	7/15/1982	32.5
564	7/16/1982	30.2
565	7/17/1982	30.5
566	7/18/1982	26.8
567	7/19/1982	29.2
568	7/20/1982	30.8
569	7/21/1982	29.8
570	7/22/1982	26.2
571	7/23/1982	30.2
572	7/24/1982	30.2
573	7/25/1982	31.9
574	7/26/1982	31.2
575	7/27/1982	31.9
576	7/28/1982	31.9
577	7/29/1982	31.9
578	7/30/1982	31.7
579	7/31/1982	31.1
580	8/1/1982	27.6
581	8/2/1982	27.9
582	8/3/1982	31.5
583	8/4/1982	31.3
584	8/5/1982	28.8
585	8/6/1982	30
586	8/7/1982	26.8
587	8/8/1982	30.9
588	8/9/1982	29.1
589	8/10/1982	25.8
590	8/11/1982	26.7
591	8/12/1982	25.2
592	8/13/1982	29.5
593	8/14/1982	31.4
594	8/15/1982	30.2
595	8/16/1982	29.6
596	8/17/1982	27.3
597	8/18/1982	31.3
598	8/19/1982	28.7
599	8/20/1982	29.8
600	8/21/1982	28
601	8/22/1982	30.7
602	8/23/1982	28
603	8/24/1982	24.2
604	8/25/1982	27
605	8/26/1982	26.8
606	8/27/1982	28.3
607	8/28/1982	29.8
608	8/29/1982	28.4
609	8/30/1982	23.5
610	8/31/1982	27.4
611	9/1/1982	27.9
612	9/2/1982	30.3
613	9/3/1982	30.9
614	9/4/1982	31.2
615	9/5/1982	30.6
616	9/6/1982	30.9
617	9/7/1982	30.1
618	9/8/1982	28.7
619	9/9/1982	28.9
620	9/10/1982	29.4
621	9/11/1982	29.2
622	9/12/1982	29.5
623	9/13/1982	29.3
624	9/14/1982	28.4
625	9/15/1982	29.7
626	9/16/1982	29.3
627	9/17/1982	30.9
628	9/18/1982	30.9
629	9/19/1982	29.4
630	9/20/1982	28.5
631	9/21/1982	19.4
632	9/22/1982	19.4
633	9/23/1982	13.9
634	9/24/1982	20.2
635	9/25/1982	22.4
636	9/26/1982	23
637	9/27/1982	23.3
638	9/28/1982	19.6
639	9/29/1982	21.3
640	9/30/1982	22.2
641	10/1/1982	23.8
642	10/2/1982	23.9
643	10/3/1982	25.3
644	10/4/1982	25.8
645	10/5/1982	25.8
646	10/6/1982	24.4
647	10/7/1982	23.9
648	10/8/1982	23
649	10/9/1982	23.3
650	10/10/1982	24.7
651	10/11/1982	24.9
652	10/12/1982	17.8
653	10/13/1982	21.7
654	10/14/1982	22.9
655	10/15/1982	24.4
656	10/16/1982	25.2
657	10/17/1982	25.1
658	10/18/1982	19.4
659	10/19/1982	21.5
660	10/20/1982	21.9
661	10/21/1982	21.9
662	10/22/1982	15.9
663	10/23/1982	15.9
664	10/24/1982	7.1
665	10/25/1982	9.9
666	10/26/1982	23.8
667	10/27/1982	23.9
668	10/28/1982	25.3
669	10/29/1982	25.8
670	10/30/1982	25.8
671	10/31/1982	11.9
672	11/1/1982	13.5
673	11/2/1982	13.3
674	11/3/1982	11.9
675	11/4/1982	11.1
676	11/5/1982	16.5
677	11/6/1982	17.4
678	11/7/1982	19.3
679	11/8/1982	18.3
680	11/9/1982	19.4
681	11/10/1982	18.7
682	11/11/1982	18.6
683	11/12/1982	19.8
684	11/13/1982	18.9
685	11/14/1982	18.5
686	11/15/1982	14.9
687	11/16/1982	7.9
688	11/17/1982	7.1
689	11/18/1982	8
690	11/19/1982	10
691	11/20/1982	8.7
692	11/21/1982	12.6
693	11/22/1982	12.4
694	11/23/1982	11.9
695	11/24/1982	13
696	11/25/1982	12.8
697	11/26/1982	12.5
698	11/27/1982	11.4
699	11/28/1982	11.1
700	11/29/1982	11.1
701	11/30/1982	10.3
702	12/1/1982	10.5
703	12/2/1982	7.5
704	12/3/1982	5.2
705	12/4/1982	5.9
706	12/5/1982	10.7
707	12/6/1982	11.8
708	12/7/1982	11.3
709	12/8/1982	4.7
710	12/9/1982	4.9
711	12/10/1982	3.6
712	12/11/1982	4.8
713	12/12/1982	5.6
714	12/13/1982	4.1
715	12/14/1982	4.6
716	12/15/1982	4.8
717	12/16/1982	9.2
718	12/17/1982	8
719	12/18/1982	10.2
720	12/19/1982	10.2
721	12/20/1982	9.7
722	12/21/1982	8.7
723	12/22/1982	8.5
724	12/23/1982	4.4
725	12/24/1982	3.4
726	12/25/1982	9.2
727	12/26/1982	10.3
728	12/27/1982	9.1
729	12/28/1982	6.5
730	12/29/1982	4.5
731	12/30/1982	8.5
732	12/31/1982	8.5
733	1/1/1983	4.9
734	1/2/1983	7.5
735	1/3/1983	7.3
736	1/4/1983	7.4
737	1/5/1983	7.7
738	1/6/1983	6.4
739	1/7/1983	4.7
740	1/8/1983	2.5
741	1/9/1983	8.7
742	1/10/1983	1.9
743	1/11/1983	5.5
744	1/12/1983	0.9
745	1/13/1983	4.3
746	1/14/1983	6.3
747	1/15/1983	5.5
748	1/16/1983	1.9
749	1/17/1983	4.1
750	1/18/1983	7.9
751	1/19/1983	9.3
752	1/20/1983	9.9
753	1/21/1983	10.2
754	1/22/1983	8
755	1/23/1983	9.3
756	1/24/1983	10.5
757	1/25/1983	13.1
758	1/26/1983	9.3
759	1/27/1983	11.1
760	1/28/1983	8.5
761	1/29/1983	2.6
762	1/30/1983	3.3
763	1/31/1983	6.9
764	2/1/1983	7.5
765	2/2/1983	7.3
766	2/3/1983	8.5
767	2/4/1983	7.8
768	2/5/1983	7.4
769	2/6/1983	8.2
770	2/7/1983	6.7
771	2/8/1983	8.7
772	2/9/1983	9.7
773	2/10/1983	10.1
774	2/11/1983	9.5
775	2/12/1983	12
776	2/13/1983	10.7
777	2/14/1983	5.2
778	2/15/1983	9.1
779	2/16/1983	3.3
780	2/17/1983	7.4
781	2/18/1983	5.5
782	2/19/1983	11.2
783	2/20/1983	11.4
784	2/21/1983	11.8
785	2/22/1983	12.2
786	2/23/1983	8.4
787	2/24/1983	7.9
788	2/25/1983	11.3
789	2/26/1983	11.7
790	2/27/1983	13.4
791	2/28/1983	13.4
792	3/1/1983	7.3
793	3/2/1983	0
794	3/3/1983	6.5
795	3/4/1983	7.4
796	3/5/1983	8.7
797	3/6/1983	8.9
798	3/7/1983	7.2
799	3/8/1983	7.3
800	3/9/1983	12.8
801	3/10/1983	12.8
802	3/11/1983	12.4
803	3/12/1983	12.5
804	3/13/1983	14.9
805	3/14/1983	16.8
806	3/15/1983	15.7
807	3/16/1983	13.5
808	3/17/1983	10.5
809	3/18/1983	5.8
810	3/19/1983	7.3
811	3/20/1983	5.2
812	3/21/1983	10.8
813	3/22/1983	12.5
814	3/23/1983	9.7
815	3/24/1983	12.5
816	3/25/1983	7.4
817	3/26/1983	7.5
818	3/27/1983	11.3
819	3/28/1983	14.5
820	3/29/1983	16.4
821	3/30/1983	16.4
822	3/31/1983	16.4
823	4/1/1983	18.1
824	4/2/1983	19.4
825	4/3/1983	14.4
826	4/4/1983	18.2
827	4/5/1983	0
828	4/6/1983	14.3
829	4/7/1983	18.9
830	4/8/1983	17.8
831	4/9/1983	15.7
832	4/10/1983	18.3
833	4/11/1983	16.2
834	4/12/1983	17.2
835	4/13/1983	13.8
836	4/14/1983	11.3
837	4/15/1983	12.1
838	4/16/1983	7.8
839	4/17/1983	7.9
840	4/18/1983	12.6
841	4/19/1983	13.9
842	4/20/1983	19.2
843	4/21/1983	20.7
844	4/22/1983	22.2
845	4/23/1983	23.9
846	4/24/1983	23.6
847	4/25/1983	23.5
848	4/26/1983	26
849	4/27/1983	22
850	4/28/1983	19.6
851	4/29/1983	23.5
852	4/30/1983	24.4
853	5/1/1983	16.6
854	5/2/1983	14.4
855	5/3/1983	20.1
856	5/4/1983	23.6
857	5/5/1983	17.1
858	5/6/1983	18.8
859	5/7/1983	24.8
860	5/8/1983	26.9
861	5/9/1983	27.3
862	5/10/1983	27.3
863	5/11/1983	27.3
864	5/12/1983	16.1
865	5/13/1983	21.8
866	5/14/1983	24.9
867	5/15/1983	24.9
868	5/16/1983	24.9
869	5/17/1983	27.9
870	5/18/1983	27.8
871	5/19/1983	22.5
872	5/20/1983	23.5
873	5/21/1983	21.7
874	5/22/1983	17.3
875	5/23/1983	17.5
876	5/24/1983	22.6
877	5/25/1983	24.6
878	5/26/1983	27.5
879	5/27/1983	26.7
880	5/28/1983	26.6
881	5/29/1983	18.9
882	5/30/1983	19.9
883	5/31/1983	26.8
884	6/1/1983	28.4
885	6/2/1983	28.4
886	6/3/1983	20.7
887	6/4/1983	19.8
888	6/5/1983	24.7
889	6/6/1983	24.5
890	6/7/1983	26.9
891	6/8/1983	28.1
892	6/9/1983	22.2
893	6/10/1983	21.9
894	6/11/1983	24.3
895	6/12/1983	24
896	6/13/1983	24.6
897	6/14/1983	26.5
898	6/15/1983	29.1
899	6/16/1983	21.5
900	6/17/1983	23.2
901	6/18/1983	24.1
902	6/19/1983	22.7
903	6/20/1983	25.5
904	6/21/1983	27.7
905	6/22/1983	30.2
906	6/23/1983	29.5
907	6/24/1983	30.5
908	6/25/1983	30.7
909	6/26/1983	30.3
910	6/27/1983	29.8
911	6/28/1983	31.1
912	6/29/1983	32.3
913	6/30/1983	32.3
914	7/1/1983	33.4
915	7/2/1983	29.1
916	7/3/1983	27.8
917	7/4/1983	23.8
918	7/5/1983	24.2
919	7/6/1983	21.7
920	7/7/1983	22.1
921	7/8/1983	24.6
922	7/9/1983	26.7
923	7/10/1983	26.2
924	7/11/1983	25.5
925	7/12/1983	25.4
926	7/13/1983	26.6
927	7/14/1983	26.5
928	7/15/1983	26.7
929	7/16/1983	27.8
930	7/17/1983	25.4
931	7/18/1983	22.5
932	7/19/1983	26.6
933	7/20/1983	29.2
934	7/21/1983	30.5
935	7/22/1983	31.3
936	7/23/1983	31.7
937	7/24/1983	25.4
938	7/25/1983	28.3
939	7/26/1983	29.3
940	7/27/1983	24.3
941	7/28/1983	25.4
942	7/29/1983	29.8
943	7/30/1983	31.1
944	7/31/1983	32.9
945	8/1/1983	33.7
946	8/2/1983	32.7
947	8/3/1983	30.5
948	8/4/1983	30.5
949	8/5/1983	30.7
950	8/6/1983	25.7
951	8/7/1983	26.9
952	8/8/1983	22.9
953	8/9/1983	27
954	8/10/1983	28.3
955	8/11/1983	27.7
956	8/12/1983	28.6
957	8/13/1983	26.2
958	8/14/1983	29.8
959	8/15/1983	29.4
960	8/16/1983	30.1
961	8/17/1983	30.2
962	8/18/1983	31.8
963	8/19/1983	26.5
964	8/20/1983	28.1
965	8/21/1983	27.5
966	8/22/1983	28.7
967	8/23/1983	28.6
968	8/24/1983	30.4
969	8/25/1983	29.4
970	8/26/1983	26.3
971	8/27/1983	28.8
972	8/28/1983	29.5
973	8/29/1983	29.6
974	8/30/1983	31.1
975	8/31/1983	31.3
976	9/1/1983	29.5
977	9/2/1983	30.5
978	9/3/1983	30.5
979	9/4/1983	27.1
980	9/5/1983	29.9
981	9/6/1983	29.8
982	9/7/1983	30.2
983	9/8/1983	30.7
984	9/9/1983	30.8
985	9/10/1983	31.5
986	9/11/1983	26.5
987	9/12/1983	29.4
988	9/13/1983	29.4
989	9/14/1983	29.6
990	9/15/1983	29.3
991	9/16/1983	24
992	9/17/1983	26.3
993	9/18/1983	25.3
994	9/19/1983	28.1
995	9/20/1983	28.8
996	9/21/1983	28.1
997	9/22/1983	27.4
998	9/23/1983	28.5
999	9/24/1983	27.1
1000	9/25/1983	29.5
1001	9/26/1983	29.9
1002	9/27/1983	29.4
1003	9/28/1983	29.6
1004	9/29/1983	29.6
1005	9/30/1983	29.6
1006	10/1/1983	29.6
1007	10/2/1983	26.9
1008	10/3/1983	26.3
1009	10/4/1983	24.1
1010	10/5/1983	26.2
1011	10/6/1983	27.5
1012	10/7/1983	28.3
1013	10/8/1983	28.5
1014	10/9/1983	28.8
1015	10/10/1983	27.3
1016	10/11/1983	25.8
1017	10/12/1983	24.5
1018	10/13/1983	26
1019	10/14/1983	22.8
1020	10/15/1983	22.8
1021	10/16/1983	16.2
1022	10/17/1983	19.3
1023	10/18/1983	20.7
1024	10/19/1983	21.5
1025	10/20/1983	21.6
1026	10/21/1983	16.5
1027	10/22/1983	18
1028	10/23/1983	18.6
1029	10/24/1983	17.1
1030	10/25/1983	18.9
1031	10/26/1983	20.1
1032	10/27/1983	20.7
1033	10/28/1983	20.1
1034	10/29/1983	21.5
1035	10/30/1983	21.3
1036	10/31/1983	22.5
1037	11/1/1983	21.7
1038	11/2/1983	21.8
1039	11/3/1983	21.8
1040	11/4/1983	21.3
1041	11/5/1983	21.7
1042	11/6/1983	18.7
1043	11/7/1983	18.7
1044	11/8/1983	13.4
1045	11/9/1983	16.7
1046	11/10/1983	17.1
1047	11/11/1983	18.1
1048	11/12/1983	17.4
1049	11/13/1983	18.2
1050	11/14/1983	18.5
1051	11/15/1983	17.9
1052	11/16/1983	19.3
1053	11/17/1983	18.6
1054	11/18/1983	18.1
1055	11/19/1983	18.1
1056	11/20/1983	18.1
1057	11/21/1983	17.3
1058	11/22/1983	17.8
1059	11/23/1983	17
1060	11/24/1983	17
1061	11/25/1983	16.8
1062	11/26/1983	16.3
1063	11/27/1983	15.5
1064	11/28/1983	19.3
1065	11/29/1983	18.6
1066	11/30/1983	18.1
1067	12/1/1983	15.4
1068	12/2/1983	12.9
1069	12/3/1983	14.8
1070	12/4/1983	13.4
1071	12/5/1983	13.8
1072	12/6/1983	13.9
1073	12/7/1983	13.2
1074	12/8/1983	13.6
1075	12/9/1983	9.7
1076	12/10/1983	15.7
1077	12/11/1983	14.9
1078	12/12/1983	10.7
1079	12/13/1983	13.3
1080	12/14/1983	9.4
1081	12/15/1983	5.1
1082	12/16/1983	7.7
1083	12/17/1983	9.5
1084	12/18/1983	8.5
1085	12/19/1983	9.7
1086	12/20/1983	5
1087	12/21/1983	5.9
1088	12/22/1983	6.4
1089	12/23/1983	6.2
1090	12/24/1983	7.2
1091	12/25/1983	8.2
1092	12/26/1983	6.9
1093	12/27/1983	7.7
1094	12/28/1983	8.1
1095	12/29/1983	9.6
1096	12/30/1983	8.3
1097	12/31/1983	10.3
Sheet1

 

[Peter_SSs]

I need to format the data like the one provided in the sheet attached

I cannot see how those dates are related to your sample data in post 1 which seems to have nothing indicating 1981.
I cannot see how you got 10.5 to be the first value from your sample data in post 1. My guess would have been that 1 Jan would have been 11.1

 

[aazimyousuf]

I cannot see how those dates are related to your sample data in post 1 which seems to have nothing indicating 1981.
I cannot see how you got 10.5 to be the first value from your sample data in post 1. My guess would have been that 1 Jan would have been 11.1

Temperature 1981-2016.xlsx
	A
1	11.1
2	10.7
3	10.7
4	11.4
5	0
6	5.4
7	7.5
8	6.2
9	4.5
10	8.9
11	8.2
12	4.5
13	5.8
14	9.3
15	5.4
16	5.7
17	7.1
18	2.5
19	4
20	9.2
21	7.3
22	7.7
23	8.8
24	8.4
25	7.3
26	7.8
27	11.7
28	10.7
29	11.1
30	11.3
31	11.3
32	13.5
33	7.1
34	4.9
35	4.2
36	3.9
37	7.8
38	4.1
39	5.7
40	3.9
41	13.5
42	7.1
43	4.9
44	4.2
45	3.9
46	7.8
47	4.1
48	5.7
49	3.9
50	2.4
51	3.5
52	7.5
53	8.5
54	9
55	7.1
56	9.7
57	2.7
58	3.9
59	3.9
Sheet3

 

[Peter_SSs]

Sub ListValues()
  Dim a As Variant, b As Variant
  Dim i As Long, j As Long, k As Long
  
  a = Sheets("Qazigund_maxtemp").Range("C108:N138").Value
  ReDim b(1 To UBound(a, 1) * UBound(a, 2), 1 To 1)
  For j = 1 To UBound(a, 2)
    For i = 1 To UBound(a, 1)
      If Len(a(i, j)) > 0 Then
        k = k + 1
        b(k, 1) = a(i, j)
      End If
    Next i
  Next j
  Sheets("Sheet3").Range("A1").Resize(k).Value = b
End Sub

 

[aazimyousuf]

Sub ListValues()
  Dim a As Variant, b As Variant
  Dim i As Long, j As Long, k As Long
 
  a = Sheets("Qazigund_maxtemp").Range("C108:N138").Value
  ReDim b(1 To UBound(a, 1) * UBound(a, 2), 1 To 1)
  For j = 1 To UBound(a, 2)
    For i = 1 To UBound(a, 1)
      If Len(a(i, j)) > 0 Then
        k = k + 1
        b(k, 1) = a(i, j)
      End If
    Next i
  Next j
  Sheets("Sheet3").Range("A1").Resize(k).Value = b
End Sub

It was one of the best tasks that I have learned, without your precious time and help it was impossible as I was trying it for the past 20 days.
Thanks a lot
Best regards
Aazim Yousuf

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.