Arrange data!

[doriannjeshi]

Hello,

I need to arrange all the columns in column A , but according to the month and year.

The list is very long , till year 1987, so I cant do it manually

1/1/1900
Jan-01	Feb-00	Mar-00	Apr-00	May-00	Jun-00
02 21:26 Aqu	01 07:48 Pis	02 18:03 Ari	01 05:01 Tau	02 22:24 Can	01 15:44 Leo
04 22:09 Pis	03 07:38 Ari	04 18:25 Tau	03 07:14 Gem	05 07:00 Leo	04 02:34 Vir
06 23:45 Ari	05 09:42 Tau	06 22:05 Gem	05 13:16 Can	07 18:35 Vir	06 14:59 Lib
09 03:26 Tau	07 15:07 Gem	09 05:45 Can	07 23:10 Leo	10 07:09 Lib	09 02:45 Sco
11 09:36 Gem	09 23:50 Can	11 16:38 Leo	10 11:24 Vir	12 18:41 Sco	11 12:05 Sag
13 18:06 Can	12 10:49 Leo	14 05:04 Vir	13 00:01 Lib	15 04:07 Sag	13 18:31 Cap
16 04:31 Leo	14 23:00 Vir	16 17:39 Lib	15 11:38 Sco	17 11:19 Cap	15 22:38 Aqu
18 16:27 Vir	17 11:36 Lib	19 05:34 Sco	17 21:38 Sag	19 16:30 Aqu	18 01:27 Pis
21 05:07 Lib	19 23:44 Sco	21 16:03 Sag	20 05:36 Cap	21 20:01 Pis	20 03:57 Ari
23 16:54 Sco	22 09:53 Sag	23 23:57 Cap	22 11:05 Aqu	23 22:21 Ari	22 06:53 Tau
26 01:50 Sag	24 16:32 Cap	26 04:25 Aqu	24 13:59 Pis	26 00:20 Tau	24 10:52 Gem
28 06:47 Cap	26 19:16 Aqu	28 05:42 Pis	26 15:00 Ari	28 03:06 Gem	26 16:28 Can
30 08:14 Aqu	28 19:05 Pis	30 05:13 Ari	28 15:34 Tau	30 07:55 Can	29 00:18 Leo
			30 17:30 Gem
Jul-00	Aug-00	Sep-00	Oct-00	Nov-00	Dec-00
01 10:42 Vir	02 19:08 Sco	01 13:48 Sag	01 05:56 Cap	01 23:06 Pis	01 08:22 Ari
03 22:59 Lib	05 06:00 Sag	03 22:27 Cap	03 12:03 Aqu	04 00:27 Ari	03 10:01 Tau
06 11:11 Sco	07 13:14 Cap	06 02:53 Aqu	05 14:22 Pis	06 00:25 Tau	05 11:27 Gem
08 21:04 Sag	09 16:32 Aqu	08 03:47 Pis	07 14:07 Ari	08 00:50 Gem	07 14:04 Can
11 03:27 Cap	11 17:11 Pis	10 03:00 Ari	09 13:17 Tau	10 03:32 Can	09 19:18 Leo
13 06:41 Aqu	13 17:09 Ari	12 02:45 Tau	11 14:02 Gem	12 09:48 Leo	12 04:03 Vir
15 08:12 Pis	15 18:24 Tau	14 04:57 Gem	13 18:01 Can	14 19:47 Vir	14 15:48 Lib
17 09:38 Ari	17 22:14 Gem	16 10:39 Can	16 01:53 Leo	17 08:08 Lib	17 04:33 Sco
19 12:16 Tau	20 04:56 Can	18 19:38 Leo	18 12:51 Vir	19 20:48 Sco	19 15:53 Sag
21 16:48 Gem	22 14:02 Leo	21 06:53 Vir	21 01:24 Lib	22 08:08 Sag	22 00:32 Cap
23 23:20 Can	25 00:57 Vir	23 19:19 Lib	23 14:04 Sco	24 17:25 Cap	24 06:34 Aqu
26 07:49 Leo	27 13:12 Lib	26 08:06 Sco	26 01:50 Sag	27 00:30 Aqu	26 10:46 Pis
28 18:17 Vir	30 02:03 Sco	28 20:10 Sag	28 11:47 Cap	29 05:23 Pis	28 14:02 Ari
31 06:29 Lib			30 19:01 Aqu		30 16:55 Tau
1901
Jan-01	Feb-01	Mar-01	Apr-01	May-01	Jun-01
01 19:54 Gem	02 13:12 Leo	01 19:30 Leo	02 21:56 Lib	02 16:43 Sco	01 11:43 Sag
03 23:35 Can	04 21:32 Vir	04 04:36 Vir	05 10:37 Sco	05 05:26 Sag	03 22:43 Cap
06 04:58 Leo	07 08:17 Lib	06 15:36 Lib	07 23:30 Sag	07 16:53 Cap	06 07:30 Aqu
08 13:03 Vir	09 20:56 Sco	09 04:11 Sco	10 11:01 Cap	10 01:58 Aqu	08 13:54 Pis
11 00:07 Lib	12 09:25 Sag	11 17:03 Sag	12 19:26 Aqu	12 07:55 Pis	10 18:01 Ari
13 12:51 Sco	14 19:09 Cap	14 03:56 Cap	14 23:56 Pis	14 10:43 Ari	12 20:10 Tau
16 00:43 Sag	17 00:50 Aqu	16 10:56 Aqu	17 01:05 Ari	16 11:17 Tau	14 21:10 Gem
18 09:29 Cap	19 03:06 Pis	18 13:52 Pis	19 00:32 Tau	18 11:07 Gem	16 22:22 Can
20 14:47 Aqu	21 03:44 Ari	20 14:06 Ari	21 00:17 Gem	20 12:03 Can	19 01:23 Leo
22 17:41 Pis	23 04:40 Tau	22 13:42 Tau	23 02:11 Can	22 15:46 Leo	21 07:40 Vir
24 19:44 Ari	25 07:21 Gem	24 14:37 Gem	25 07:27 Leo	24 23:18 Vir	23 17:41 Lib
26 22:15 Tau	27 12:20 Can	26 18:14 Can	27 16:19 Vir	27 10:17 Lib	26 06:13 Sco
29 01:54 Gem		29 01:00 Leo	30 03:53 Lib	29 23:07 Sco	28 18:50 Sag
31 06:49 Can		31 10:29 Vir
Jul-01	Aug-01	Sep-01	Oct-01	Nov-01	Dec-01
01 05:30 Cap	02 01:59 Pis	02 14:17 Tau	01 23:27 Gem	02 13:08 Leo	02 03:02 Vir
03 13:33 Aqu	04 05:16 Ari	04 16:32 Gem	04 01:54 Can	04 20:05 Vir	04 12:22 Lib
05 19:22 Pis	06 08:06 Tau	06 20:10 Can	06 06:52 Leo	07 06:14 Lib	07 00:38 Sco
07 23:36 Ari	08 11:07 Gem	09 01:26 Leo	08 14:27 Vir	09 18:29 Sco	09 13:44 Sag
10 02:44 Tau	10 14:37 Can	11 08:32 Vir	11 00:25 Lib	12 07:32 Sag	12 02:03 Cap
12 05:10 Gem	12 19:03 Leo	13 17:52 Lib	13 12:19 Sco	14 20:08 Cap	14 12:41 Aqu
14 07:31 Can	15 01:17 Vir	16 05:30 Sco	16 01:21 Sag	17 07:03 Aqu	16 21:11 Pis
16 10:54 Leo	17 10:13 Lib	18 18:32 Sag	18 14:00 Cap	19 15:03 Pis	19 03:09 Ari
18 16:42 Vir	19 21:57 Sco	21 06:43 Cap	21 00:17 Aqu	21 19:31 Ari	21 06:23 Tau
21 01:54 Lib	22 10:52 Sag	23 15:44 Aqu	23 06:45 Pis	23 20:51 Tau	23 07:22 Gem
23 13:59 Sco	24 22:17 Cap	25 20:42 Pis	25 09:26 Ari	25 20:24 Gem	25 07:23 Can
26 02:45 Sag	27 06:13 Aqu	27 22:29 Ari	27 09:34 Tau	27 20:02 Can	27 08:18 Leo
28 13:32 Cap	29 10:36 Pis	29 22:47 Tau	29 09:01 Gem	29 21:43 Leo	29 12:03 Vir
30 21:09 Aqu	31 12:44 Ari		31 09:42 Can		31 19:55 Lib
1902
Jan-02	Feb-02	Mar-02	Apr-02	May-02	Jun-02
03 07:29 Sco	02 04:16 Sag	01 12:26 Sag	02 20:19 Aqu	02 13:15 Pis	01 03:35 Ari
05 20:35 Sag	04 16:37 Cap	04 01:03 Cap	05 04:03 Pis	04 18:29 Ari	03 06:46 Tau
08 08:46 Cap	07 02:27 Aqu	06 11:21 Aqu	07 08:11 Ari	06 20:23 Tau	05 07:10 Gem
10 18:48 Aqu	09 09:29 Pis	08 18:16 Pis	09 09:50 Tau	08 20:21 Gem	07 06:27 Can
13 02:40 Pis	11 14:30 Ari	10 22:21 Ari	11 10:37 Gem	10 20:15 Can	09 06:39 Leo
15 08:43 Ari	13 18:25 Tau	13 00:55 Tau	13 12:03 Can	12 21:54 Leo	11 09:43 Vir
17 13:05 Tau	15 21:43 Gem	15 03:13 Gem	15 15:18 Leo	15 02:35 Vir	13 16:44 Lib
19 15:49 Gem	18 00:36 Can	17 06:03 Can	17 20:56 Vir	17 10:41 Lib	16 03:22 Sco
21 17:22 Can	20 03:36 Leo	19 09:54 Leo	20 05:04 Lib	19 21:32 Sco	18 15:57 Sag
23 18:56 Leo	22 07:44 Vir	21 15:12 Vir	22 15:27 Sco	22 09:57 Sag	21 04:45 Cap
25 22:15 Vir	24 14:17 Lib	23 22:30 Lib	25 03:35 Sag	24 22:46 Cap	23 16:37 Aqu
28 04:57 Lib	27 00:05 Sco	26 08:19 Sco	27 16:25 Cap	27 10:49 Aqu	26 02:50 Pis
30 15:27 Sco		28 20:24 Sag	30 04:15 Aqu	29 20:49 Pis	28 10:39 Ari
		31 09:11 Cap			30 15:26 Tau
Jul-02	Aug-02	Sep-02	Oct-02	Nov-02	Dec-02
02 17:14 Gem	01 02:34 Can	01 14:13 Vir	01 03:18 Lib	02 05:25 Sag	02 00:32 Cap
04 17:07 Can	03 03:06 Leo	03 18:42 Lib	03 11:06 Sco	04 17:43 Cap	04 13:15 Aqu
06 16:55 Leo	05 04:42 Vir	06 02:25 Sco	05 21:39 Sag	07 06:21 Aqu	07 01:01 Pis
08 18:43 Vir	07 09:14 Lib	08 13:24 Sag	08 10:05 Cap	09 17:15 Pis	09 10:02 Ari
11 00:16 Lib	09 17:42 Sco	11 02:00 Cap	10 22:18 Aqu	12 00:43 Ari	11 15:10 Tau
13 09:54 Sco	12 05:25 Sag	13 13:43 Aqu	13 08:06 Pis	14 04:24 Tau	13 16:38 Gem
15 22:16 Sag	14 18:09 Cap	15 22:52 Pis	15 14:30 Ari	16 05:19 Gem	15 15:56 Can
18 11:03 Cap	17 05:37 Aqu	18 05:13 Ari	17 17:56 Tau	18 05:14 Can	17 15:13 Leo
20 22:37 Aqu	19 14:50 Pis	20 09:31 Tau	19 19:40 Gem	20 06:05 Leo	19 16:40 Vir
23 08:23 Pis	21 21:56 Ari	22 12:39 Gem	21 21:10 Can	22 09:23 Vir	21 21:45 Lib
25 16:15 Ari	24 03:19 Tau	24 15:22 Can	23 23:38 Leo	24 15:48 Lib	24 06:38 Sco
27 21:56 Tau	26 07:13 Gem	26 18:16 Leo	26 03:53 Vir	27 01:01 Sco	26 18:08 Sag
30 01:15 Gem	28 09:49 Can	28 21:58 Vir	28 10:13 Lib	29 12:11 Sag	29 06:43 Cap
	30 11:45 Leo		30 18:45 Sco		31 19:19 Aqu

 

[PeteWright]

Hello!

Is this the result or the input data that you posted? And how should it be arranged? Please be more specific.

 

[doriannjeshi]

Hi,
I am trying to get this dates table into a single column to use it for look up , should look like this:

1/1/1900
02 21:26 Aqu
04 22:09 Pis
06 23:45 Ari
09 03:26 Tau
11 09:36 Gem
13 18:06 Can
16 04:31 Leo
18 16:27 Vir
21 05:07 Lib
23 16:54 Sco
26 01:50 Sag
28 06:47 Cap
30 08:14 Aqu
Feb-00
01 07:48 Pis
03 07:38 Ari
05 09:42 Tau
07 15:07 Gem
09 23:50 Can
12 10:49 Leo
14 23:00 Vir
17 11:36 Lib
19 23:44 Sco
22 09:53 Sag
24 16:32 Cap
26 19:16 Aqu
28 19:05 Pis
Mar-00
02 18:03 Ari
04 18:25 Tau
06 22:05 Gem
09 05:45 Can
11 16:38 Leo
14 05:04 Vir
16 17:39 Lib
19 05:34 Sco
21 16:03 Sag
23 23:57 Cap
26 04:25 Aqu
28 05:42 Pis
30 05:13 Ari
Apr-00
01 05:01 Tau
03 07:14 Gem
05 13:16 Can
07 23:10 Leo
10 11:24 Vir
13 00:01 Lib
15 11:38 Sco
17 21:38 Sag
20 05:36 Cap
22 11:05 Aqu
24 13:59 Pis
26 15:00 Ari
28 15:34 Tau
30 17:30 Gem
May-00
02 22:24 Can
05 07:00 Leo
07 18:35 Vir
10 07:09 Lib
12 18:41 Sco
15 04:07 Sag
17 11:19 Cap
19 16:30 Aqu
21 20:01 Pis
23 22:21 Ari
26 00:20 Tau
28 03:06 Gem
30 07:55 Can
Jun-00
01 15:44 Leo
04 02:34 Vir
06 14:59 Lib
09 02:45 Sco
11 12:05 Sag
13 18:31 Cap
15 22:38 Aqu
18 01:27 Pis
20 03:57 Ari
22 06:53 Tau
24 10:52 Gem
26 16:28 Can
29 00:18 Leo
Jul-00
01 10:42 Vir
03 22:59 Lib
06 11:11 Sco
08 21:04 Sag
11 03:27 Cap
13 06:41 Aqu
15 08:12 Pis
17 09:38 Ari
19 12:16 Tau
21 16:48 Gem
23 23:20 Can
26 07:49 Leo
28 18:17 Vir
31 06:29 Lib
Aug-00
02 19:08 Sco
05 06:00 Sag
07 13:14 Cap
09 16:32 Aqu
11 17:11 Pis
13 17:09 Ari
15 18:24 Tau
17 22:14 Gem
20 04:56 Can
22 14:02 Leo
25 00:57 Vir
27 13:12 Lib
30 02:03 Sco
Sep-00
01 13:48 Sag
03 22:27 Cap
06 02:53 Aqu
08 03:47 Pis
10 03:00 Ari
12 02:45 Tau
14 04:57 Gem
16 10:39 Can
18 19:38 Leo
21 06:53 Vir
23 19:19 Lib
26 08:06 Sco
28 20:10 Sag
Oct-00
01 05:56 Cap
03 12:03 Aqu
05 14:22 Pis
07 14:07 Ari
09 13:17 Tau
11 14:02 Gem
13 18:01 Can
16 01:53 Leo
18 12:51 Vir
21 01:24 Lib
23 14:04 Sco
26 01:50 Sag
28 11:47 Cap
30 19:01 Aqu
Nov-00
01 23:06 Pis
04 00:27 Ari
06 00:25 Tau
08 00:50 Gem
10 03:32 Can
12 09:48 Leo
14 19:47 Vir
17 08:08 Lib
19 20:48 Sco
22 08:08 Sag
24 17:25 Cap
27 00:30 Aqu
29 05:23 Pis
Dec-00
01 08:22 Ari
03 10:01 Tau
05 11:27 Gem
07 14:04 Can
09 19:18 Leo
12 04:03 Vir
14 15:48 Lib
17 04:33 Sco
19 15:53 Sag
22 00:32 Cap
24 06:34 Aqu
26 10:46 Pis
28 14:02 Ari
30 16:55 Tau
1901
Jan-01
01 19:54 Gem
03 23:35 Can
06 04:58 Leo
08 13:03 Vir
11 00:07 Lib
13 12:51 Sco
16 00:43 Sag
18 09:29 Cap
20 14:47 Aqu
22 17:41 Pis
24 19:44 Ari
26 22:15 Tau
29 01:54 Gem
31 06:49 Can

 

[shinigamilight]

 

[doriannjeshi]

Thank you shinigamilight !
I am trying the solution , and it would work if my table flow wasn't horizontal- vertical - horizontal vertical ..