+ Reply to Thread
Results 1 to 6 of 6

Help transposing data!!!

  1. 04-14-2014, 10:12 PM #1
    cory0789
    cory0789 is offline
    Forum Contributor
    Join Date
    04-14-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    198

    Angry Help transposing data!!!

    I have a huge worksheet with thousands of rows and columns... I need to figure out how I can transpose all of the data, it can go to another worksheet or whatever is easiest but here is where I run into a problem... All of row A should be my column headers... So A1 through A5000 or whatever should be A1,B1,C1,D1 and so on.... But all of ROW 1 is dates so JAN 1, jan 1, jan 2, jan 2, feb 3, feb 3, and so on depending on order dates... So what I need to do is move All of the data with each row should go into a column and fill in the A column with a date... so instead of
    a c d e f g h
    1 jan 1 jan 2 jan 3 jan 7 feb 3
    2 price 500 700 8000 900
    3 location here there mars other
    4 quantity 4 10 8 99
    5 other test here and there
    6

    I need the data above from row 2 to go into a column under price.... but their may be 50 prices under JAN 1 so how do I get the data to do this and continue to label each ROW with the proper date...

    Someone please help me out here.


    Thanks,
    Reply With QuoteRegister To Reply
  2. 04-14-2014, 10:40 PM #2
    cory0789
    cory0789 is offline
    Forum Contributor
    Join Date
    04-14-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    198

    Re: Help transposing data!!! 

    Please Login or Register  to view this content.




    This code would work but I need it to put where it is repeating the A column down the line I need the A column to be A,B,C,D,E or the HEADERS and it needs to repeat the current A1,B1,C1 (HEADERS) which are dates, other than that it seems to do what I need. I cant seem to twist it the proper way to get it fixed. That is the base code I got from another thread on this forum. I have changed it but not enough worth posting so yea...
    Last edited by FDibbins; 04-14-2014 at 10:55 PM.
    Reply With QuoteRegister To Reply
  3. 04-14-2014, 10:55 PM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Help transposing data!!!

    Cory, hi and welcome to the forum

    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    I will add them for you - this time
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  4. 04-14-2014, 10:56 PM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Help transposing data!!!

    Have you tried copy/paste transpose?
    Reply With QuoteRegister To Reply
  5. 04-14-2014, 11:00 PM #5
    sktneer
    sktneer is offline
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Help transposing data!!!

    You may try this code to see if this works as per your requirement. In the code Sheet1 is the source sheet where you original data is stored and Sheet2 is the target sheet where you want to put the transposed data. If sheets names are different in your workbook, please change the sheet names in the code.
    Please Login or Register  to view this content.
    Regards
    sktneer

    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.
    Reply With QuoteRegister To Reply
  6. 09-09-2014, 07:21 AM #6
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Help transposing data!!!

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Transposing Data
    By patrickdjames in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-08-2013, 12:53 PM
  2. Transposing list of values with 6 zeroes in front to retain the zero after transposing
    By Lisa4legin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-16-2013, 03:34 AM
  3. [SOLVED] Transposing data and more?
    By rjmcmillen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2012, 05:58 PM
  4. Example - transposing data
    By Mel93 in forum Excel General
    Replies: 2
    Last Post: 10-06-2010, 07:09 PM
  5. [SOLVED] transposing vertical data to horizontal with varying amount of data
    By Ghosty in forum Excel General
    Replies: 5
    Last Post: 08-01-2006, 12:23 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1