Yes use the Transpose option to do it.

Just insert a column in between A&B Column. Now your data will start from C
column and end on column AB. Now select the data from Column C to Column AB
and do copy. Place the cursor in B Column (i.e. newly inserted column) and
do Right ClickPaste Special€¦Check the Transpose Field.

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"Buyone" wrote:

Hello,

I have a set of data that i need to modify.
A B C D E ......AA
14-Oct 03:23 04:23 06:20 06:34

I need to transpose B:AA into a single column while keeping the date in A.

So it should look like

A B
14-Oct 03:23
14-Oct 04:23
14-Oct 06:20

This data goes on for a number of rows so doing it manually (as i have been
doing) can take hrs.

Can anyone save me from my excel hell?

Thanks in advance