Arranging multiple columns

[Joe Rdz]

I would like to know if there's a way to arrange multiple columns into one, it's information I copy&pasted online so it's all messy and it's hard to work with that since it's a huge amount of data, what I want to do is move the cell that says 3:29 in column F to column E, and column G to F. It doesn't matter if any information gets erased, the only data that matters to me are column E and F. Or... I was thinking about maybe something like a vlookup formula to display all the data that I need in just 1 column, but I'm not good enough to make it work by myself. Thanks in advance.

A	B	C	D	E	F	G
6:28:00	a.m.	11:02:00	a.m.	4:37	46:22:00
11:42:00	a.m.	2:47:00	p.m.	2:59	49:21:00
6:54:00	a.m.	11:00:00	a.m.	4:06	53:27:00
11:30:00	a.m.	11:40:00	a.m.	0:10	53:37:00
a.m.	11:40:00	a.m.	3:09:00	p.m.	3:29	57:06:00

<tbody>
</tbody>

 

[NiMip]

If the error is consistently as you've pasted, then this could work. I'm a bit worried that the stray "a.m." has come from somewhere though. Hard to say without seeing the full data set.
Fill the formula from I1 down and across I1:N5

A

B

C

D

E

F

G

H

I

J

K

L

M

N

1

6:28:00

a.m.

11:02:00

a.m.

4:37:00

22:22:00

=IF(ISNUMBER($A1),A1,B1)

a.m.

11:02:00

a.m.

4:37:00

22:22:00

2

11:42:00

a.m.

2:47:00

p.m.

2:59:00

1:21:00

11:42:00

a.m.

2:47:00

p.m.

2:59:00

1:21:00

3

6:54:00

a.m.

11:00:00

a.m.

4:06:00

5:27:00

6:54:00

a.m.

11:00:00

a.m.

4:06:00

5:27:00

4

11:30:00

a.m.

11:40:00

a.m.

0:10:00

5:37:00

11:30:00

a.m.

11:40:00

a.m.

0:10:00

5:37:00

5

a.m.

11:40:00

a.m.

3:09:00

p.m.

3:29:00

9:06:00

11:40:00

a.m.

3:09:00

p.m.

3:29:00

9:06:00

<tbody>
</tbody>

EDIT: You'll likely need to paste the formatting of cell A1 to the other columns - they'll probably just come up as decimals when the formula is entered.