+ Reply to Thread
Results 1 to 6 of 6

Copy and Paste with Transpose function

  1. #1
    Registered User
    Join Date
    02-04-2014
    Location
    United States
    MS-Off Ver
    MS office 365
    Posts
    9

    Copy and Paste with Transpose function

    Hello, I have a situation where i need to reorganize the data that comes in one column to a table with multiple columns. I tried using transpose function but it takes an enormous amount of time due to a huge amount of source data. Here is the example. I'm sure there is an easier way to reorganize the data in the columns, but I haven't been able to come up with it yet. I'd appreciate any advise. Thanks!

    image.png

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,926

    Re: Copy and Paste with Transpose function

    A picture is not much use to us, and we can't see which rows and columns you are using. It would be more helpful if you attached a sample Excel workbook, as detailed in the yellow banner near the top of the screen.

    Also, please confirm the version of Excel that you are currently using, and update your profile on User CP to show this if it has changed since your first joined ten years ago.

    Hope this helps.

    Pete

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    45,474

    Re: Copy and Paste with Transpose function

    If you have upgraded to Excel 365, then:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    With headings:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by TMS; 06-12-2024 at 06:57 PM.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Registered User
    Join Date
    02-04-2014
    Location
    United States
    MS-Off Ver
    MS office 365
    Posts
    9

    Re: Copy and Paste with Transpose function

    [QUOTE=TMS;5958253]If you have upgraded to Excel 365, then:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    With headings:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    [/QUOTE

    You are a life saver!!! Thank you so much!

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    45,474

    Re: Copy and Paste with Transpose function

    You're welcome.

    Please update your User Profile to reflect the version of Excel you are using. Thanks.


    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon (Next to Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    45,474

    Re: Copy and Paste with Transpose function

    Thanks for the rep.


    And thanks for updating your user profile.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copy and Paste Transpose using VBA
    By abduldedysubhansyah in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-30-2023, 09:16 AM
  2. [SOLVED] Copy, Transpose & Paste
    By Vcare in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-01-2018, 09:10 AM
  3. [SOLVED] Copy Transpose Paste
    By Vcare in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-08-2017, 04:34 AM
  4. Copy from Array in ActiveWorkbook to ThisWorkbook; Transpose copy, Offset Paste
    By sbradley in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-14-2013, 05:17 PM
  5. Transpose without copy and paste
    By SSS777 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-10-2013, 02:24 AM
  6. [SOLVED] Visual Basic: looping a copy / paste and transpose function
    By Frey in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-11-2012, 08:25 AM
  7. [SOLVED] Copy paste and transpose
    By gilko86 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-10-2012, 12:23 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1