Posted to microsoft.public.excel.misc

external usenet poster

Posts: 16

Transpose or Macro?

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I group and transpose data - macro help needed.	Chris Mitchell	Excel Worksheet Functions	4	January 20th 09 02:35 PM
Do I need a Macro to do Transpose in this case?	Ting	Excel Discussion (Misc queries)	3	February 28th 08 06:19 PM
I need a macro to transpose multiple columns A1-Z1, A2-X2 etc	Wombat62	Excel Discussion (Misc queries)	7	September 18th 06 05:05 AM
Transpose Macro	Spil	Excel Worksheet Functions	1	July 14th 05 09:28 AM
Transpose date macro	Henry Lifton	Excel Worksheet Functions	2	March 16th 05 06:12 PM

All times are GMT +1. The time now is 05:42 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us