Results 1 to 3 of 3

Thread: How to transpose
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2017
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to transpose

    I have data that is material description July Aug Sept. The forecast is below each month. I will like the format to be
    Mat Des Jan Forecast
    Mat Des Feb Forecast

    Essentially, I will like to transpose the months and Forecast. I hve 80 unique material numbers.

    What is the quickest way of getting this done? I think a Macro or VBA but I am not skilled in this operation
    Last edited by uwish7; May 20th, 2019 at 06:17 PM.

  2. #2
    Board Regular alansidman's Avatar
    Join Date
    Feb 2007
    Location
    Steamboat Springs
    Posts
    4,935
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to transpose

    If you are using Excel 2010 or later, this can be easily accomplished using Power Query/Get and Transform.
    Let me know if that works for you
    Alan

    Am Yisrael Chai

    Win 10--Office 2019
    When Posting Code, please use code tags.
    How to insert Mcode to Power Query https://excel.solutions/2017/11/powe...te-code-video/


  3. #3
    New Member
    Join Date
    May 2018
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to transpose

    If I understand correctly you want to convert cross-tab data into a list? As to "unpivot" the data?

    If so, you can use this 3min video

    https://www.youtube.com/watch?v=pUXJLzqlEPk

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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