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.

[TABLE="align: left"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[/TR]
[TR]
[TD="align: right"]6:28:00[/TD]
[TD="align: left"]a.m.[/TD]
[TD="align: right"]11:02:00[/TD]
[TD="align: left"]a.m.[/TD]
[TD="align: right"]4:37[/TD]
[TD="align: right"]46:22:00[/TD]
[TD="align: left"][/TD]
[/TR]
[TR]
[TD="align: right"]11:42:00[/TD]
[TD="align: left"]a.m.[/TD]
[TD="align: right"]2:47:00[/TD]
[TD="align: left"]p.m.[/TD]
[TD="align: right"]2:59[/TD]
[TD="align: right"]49:21:00[/TD]
[TD="align: left"][/TD]
[/TR]
[TR]
[TD="align: right"]6:54:00[/TD]
[TD="align: left"]a.m.[/TD]
[TD="align: right"]11:00:00[/TD]
[TD="align: left"]a.m.[/TD]
[TD="align: right"]4:06[/TD]
[TD="align: right"]53:27:00[/TD]
[TD="align: left"][/TD]
[/TR]
[TR]
[TD="align: right"]11:30:00[/TD]
[TD="align: left"]a.m.[/TD]
[TD="align: right"]11:40:00[/TD]
[TD="align: left"]a.m.[/TD]
[TD="align: right"]0:10[/TD]
[TD="align: right"]53:37:00[/TD]
[TD="align: left"][/TD]
[/TR]
[TR]
[TD="align: left"]a.m.[/TD]
[TD="align: right"]11:40:00[/TD]
[TD="align: left"]a.m.[/TD]
[TD="align: right"]3:09:00[/TD]
[TD="align: left"]p.m.[/TD]
[TD="align: right"]3:29[/TD]
[TD="align: right"]57:06:00[/TD]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]

 

[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

[TABLE="class: grid, width: 896"]
<tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"]A[/TD]
[TD="width: 64"]B[/TD]
[TD="width: 64"]C[/TD]
[TD="width: 64"]D[/TD]
[TD="width: 64"]E[/TD]
[TD="width: 64"]F[/TD]
[TD="width: 64"]G[/TD]
[TD="width: 64"]H[/TD]
[TD="width: 64"]I[/TD]
[TD="width: 64"]J[/TD]
[TD="width: 64"]K[/TD]
[TD="width: 64"]L[/TD]
[TD="width: 64"]M[/TD]
[TD="width: 64"]N[/TD]
[/TR]
[TR]
[TD="width: 64"]1[/TD]
[TD="width: 64"]6:28:00[/TD]
[TD="width: 64"]a.m.[/TD]
[TD="width: 64"]11:02:00[/TD]
[TD="width: 64"]a.m.[/TD]
[TD="width: 64"]4:37:00[/TD]
[TD="width: 64"]22:22:00[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"]=IF(ISNUMBER($A1),A1,B1)[/TD]
[TD="width: 64"]a.m.[/TD]
[TD="width: 64"]11:02:00[/TD]
[TD="width: 64"]a.m.[/TD]
[TD="width: 64"]4:37:00[/TD]
[TD="width: 64"]22:22:00[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]11:42:00[/TD]
[TD]a.m.[/TD]
[TD]2:47:00[/TD]
[TD]p.m.[/TD]
[TD]2:59:00[/TD]
[TD]1:21:00[/TD]
[TD][/TD]
[TD][/TD]
[TD]11:42:00[/TD]
[TD]a.m.[/TD]
[TD]2:47:00[/TD]
[TD]p.m.[/TD]
[TD]2:59:00[/TD]
[TD]1:21:00[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]6:54:00[/TD]
[TD]a.m.[/TD]
[TD]11:00:00[/TD]
[TD]a.m.[/TD]
[TD]4:06:00[/TD]
[TD]5:27:00[/TD]
[TD][/TD]
[TD][/TD]
[TD]6:54:00[/TD]
[TD]a.m.[/TD]
[TD]11:00:00[/TD]
[TD]a.m.[/TD]
[TD]4:06:00[/TD]
[TD]5:27:00[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]11:30:00[/TD]
[TD]a.m.[/TD]
[TD]11:40:00[/TD]
[TD]a.m.[/TD]
[TD]0:10:00[/TD]
[TD]5:37:00[/TD]
[TD][/TD]
[TD][/TD]
[TD]11:30:00[/TD]
[TD]a.m.[/TD]
[TD]11:40:00[/TD]
[TD]a.m.[/TD]
[TD]0:10:00[/TD]
[TD]5:37:00[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]a.m.[/TD]
[TD]11:40:00[/TD]
[TD]a.m.[/TD]
[TD]3:09:00[/TD]
[TD]p.m.[/TD]
[TD]3:29:00[/TD]
[TD]9:06:00[/TD]
[TD][/TD]
[TD]11:40:00[/TD]
[TD]a.m.[/TD]
[TD]3:09:00[/TD]
[TD]p.m.[/TD]
[TD]3:29:00[/TD]
[TD]9:06:00[/TD]
[/TR]
</tbody>[/TABLE]


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.