Excel General Help

PSK_

NaveenHS wrote:

Is there any option to convert all rows to Columns at once ...

Rotate your monitor by 90° :laugh:

WWW, WCF, WWF, WPF, WFC .... WTF

NormDroid

Try asking the manufacturers of the software.

Two heads are better than one.

NaveenHS

Its of no use ...cant work with 90 deg tilted monitor :) ...

PSK_

NaveenHS wrote:

cant work with 90 deg tilted monitor

This was not mentioned in the initial requirement. :laugh:

WWW, WCF, WWF, WPF, WFC .... WTF

NaveenHS

It will be mentioned in the Final one ... :omg:

Peter_in_2780

OK, we've had enough fun with you. Try this (but make sure you have JS enabled in your browser!) :)

Software rusts. Simon Stephenson, ca 1994.

Roger Wright

I so hate feature creep... :sigh:

Will Rogers never met me.

moon_stick

The standard Excel transpose solution isn't going to work here - you'll need to write a macro to a task like this.

Sarchasm : The gulf between the author of sarcastic wit and the person who doesn't get it.

Eaverae

Or just use another program for data storage.. ;)

"My personality is not represented by my hometown."

NaveenHS

Thanks Peter... I have tried the same ..but i have to do every row at a time ...there are 100 rows its difficult if i select all the rows i get the contents in one row .. :( so any alternate method ? Please let me know ..

Dalek Dave

That won't work, that will move all rows to columns. As far as I can tell he wants the 'Blocks' transposed, so that this... Name 1 Organization 1 Organization 1 Mail Id Appears as a block, and repeats horizontally. It can be done, but you will have to right some VBA for it.

------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC League Table Link CCC Link[^]

Peter_in_2780

Dalek Dave wrote:

you will have to right some VBA for it

:wtf: Is that as in 'right the ship'? As an Engineer, I haven't touched VBA, and I don't intend to start now. Maybe your professional accounting skills could be applied to the benefit of the OP. ;P

Software rusts. Simon Stephenson, ca 1994.

Dalek Dave

Oh god, it is too early.

------------------------------------ I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave CCC League Table Link CCC Link[^]

Peter_in_2780

Knockoff time here! The aroma of the Lamb Korma has reached my home office, so it's time to go sit by the fire for a few minutes before I put the rice on. :) :) [there should be a 'licking lips yum yum' smiley]

Software rusts. Simon Stephenson, ca 1994.

Henry Minute

Roger Wright wrote:

I so hate feature creep...

C'mon Roger, by our age you should be getting used to it, an inevitable result of the passage of time. BTW: Have you started working nights, or just not got to bed yet?

Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”

Bassam Abdul Baki

Copy and paste into Word. Replace "^p" (carriage return) with "^t" (tab). Replace "^tMail" with "^pMail". Copy and paste into Excel.

Dan Neely

I've always just used a text editor with regex support to do that sort of thing.

3x12=36 2x12=24 1x12=12 0x12=18

Roger Wright

Though I need to be up at 5 AM, I rarely get to bed before 12M. You can't really change a nightowl, which I've been since childhood... :doh:

Will Rogers never met me.