Excel General Help
-
Hello Everyone, I have some Rows of data, like Name 1 Organization 1 Organization 1 Mail Id Name 2 Organization 1 Organization 1 Mail Id Name 3 Organization 1 Organization 1 Mail Id Is there any option to convert all rows to Columns at once ... i tried the Paste Special option but it puts all the 3 rows data to one row i trying with this format in each rows Name 1 Organization 1 Organization 1 Mail Id Name 2 Organization 1 Organization 1 Mail Id Please help me with this .... Thanking you, Naveen HS
-
Hello Everyone, I have some Rows of data, like Name 1 Organization 1 Organization 1 Mail Id Name 2 Organization 1 Organization 1 Mail Id Name 3 Organization 1 Organization 1 Mail Id Is there any option to convert all rows to Columns at once ... i tried the Paste Special option but it puts all the 3 rows data to one row i trying with this format in each rows Name 1 Organization 1 Organization 1 Mail Id Name 2 Organization 1 Organization 1 Mail Id Please help me with this .... Thanking you, Naveen HS
You should be asking this sort of question in either the Questions & Answers forum or one of the more specific ones. You may be lucky and get an answer here, but you are far more likely to get slated.
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.”
-
You should be asking this sort of question in either the Questions & Answers forum or one of the more specific ones. You may be lucky and get an answer here, but you are far more likely to get slated.
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.”
-
Hello Everyone, I have some Rows of data, like Name 1 Organization 1 Organization 1 Mail Id Name 2 Organization 1 Organization 1 Mail Id Name 3 Organization 1 Organization 1 Mail Id Is there any option to convert all rows to Columns at once ... i tried the Paste Special option but it puts all the 3 rows data to one row i trying with this format in each rows Name 1 Organization 1 Organization 1 Mail Id Name 2 Organization 1 Organization 1 Mail Id Please help me with this .... Thanking you, Naveen HS
-
Hello Everyone, I have some Rows of data, like Name 1 Organization 1 Organization 1 Mail Id Name 2 Organization 1 Organization 1 Mail Id Name 3 Organization 1 Organization 1 Mail Id Is there any option to convert all rows to Columns at once ... i tried the Paste Special option but it puts all the 3 rows data to one row i trying with this format in each rows Name 1 Organization 1 Organization 1 Mail Id Name 2 Organization 1 Organization 1 Mail Id Please help me with this .... Thanking you, Naveen HS
-
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
-
NaveenHS wrote:
cant work with 90 deg tilted monitor
This was not mentioned in the initial requirement. :laugh:
WWW, WCF, WWF, WPF, WFC .... WTF
-
Hello Everyone, I have some Rows of data, like Name 1 Organization 1 Organization 1 Mail Id Name 2 Organization 1 Organization 1 Mail Id Name 3 Organization 1 Organization 1 Mail Id Is there any option to convert all rows to Columns at once ... i tried the Paste Special option but it puts all the 3 rows data to one row i trying with this format in each rows Name 1 Organization 1 Organization 1 Mail Id Name 2 Organization 1 Organization 1 Mail Id Please help me with this .... Thanking you, Naveen HS
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.
-
NaveenHS wrote:
cant work with 90 deg tilted monitor
This was not mentioned in the initial requirement. :laugh:
WWW, WCF, WWF, WPF, WFC .... WTF
I so hate feature creep... :sigh:
Will Rogers never met me.
-
Hello Everyone, I have some Rows of data, like Name 1 Organization 1 Organization 1 Mail Id Name 2 Organization 1 Organization 1 Mail Id Name 3 Organization 1 Organization 1 Mail Id Is there any option to convert all rows to Columns at once ... i tried the Paste Special option but it puts all the 3 rows data to one row i trying with this format in each rows Name 1 Organization 1 Organization 1 Mail Id Name 2 Organization 1 Organization 1 Mail Id Please help me with this .... Thanking you, Naveen HS
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.
-
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.
-
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.
-
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.
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[^]
-
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[^]
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 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.
-
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.
-
I so hate feature creep... :sigh:
Will Rogers never met me.
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.”
-
Hello Everyone, I have some Rows of data, like Name 1 Organization 1 Organization 1 Mail Id Name 2 Organization 1 Organization 1 Mail Id Name 3 Organization 1 Organization 1 Mail Id Is there any option to convert all rows to Columns at once ... i tried the Paste Special option but it puts all the 3 rows data to one row i trying with this format in each rows Name 1 Organization 1 Organization 1 Mail Id Name 2 Organization 1 Organization 1 Mail Id Please help me with this .... Thanking you, Naveen HS
Copy and paste into Word. Replace "^p" (carriage return) with "^t" (tab). Replace "^tMail" with "^pMail". Copy and paste into Excel.
-
Hello Everyone, I have some Rows of data, like Name 1 Organization 1 Organization 1 Mail Id Name 2 Organization 1 Organization 1 Mail Id Name 3 Organization 1 Organization 1 Mail Id Is there any option to convert all rows to Columns at once ... i tried the Paste Special option but it puts all the 3 rows data to one row i trying with this format in each rows Name 1 Organization 1 Organization 1 Mail Id Name 2 Organization 1 Organization 1 Mail Id Please help me with this .... Thanking you, Naveen HS