Excel General Help
-
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
-
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.”
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.