Consulting

Results 1 to 8 of 8

Thread: Need Help : How to do convert 1 table to another format

  1. #1

    Need Help : How to do convert 1 table to another format

    Hi,

    i have been banging my head as im currently experiencing a mental block.
    I need to do a conversion of table of raw data to a different format.

    Raw Data
    Date Day ProductA ProductB
    01/01/2019 Tue 10 5
    02/01/2019 Wed 5 10
    03/01/2019 Thu 14 14
    04/01/2019 Fri 15 18


    New Table Data
    Date Day Product Volume
    01/01/2019 Tue ProductA 10
    01/01/2019 Tue ProductB 5
    02/01/2019 Wed ProductA 5
    02/01/2019 Wed ProductB 10
    03/01/2019 Thu ProductA 14
    03/01/2019 Thu ProductB 14
    04/01/2019 Fri ProductA 15
    04/01/2019 Fri ProductB 18
    Any help will be greatly appreciated.

  2. #2
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,844
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  3. #3
    cannot access the link.

  4. #4
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,844
    Quote Originally Posted by labo2002 View Post
    cannot access the link.
    Funny, I tested it from another computer. It's an mp4 file which might need a player of some sort. Are you able to download and save it to your computer?
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  5. #5
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,711
    Location
    I have to do something like that all the time to make a 'two dimensional' block of data into a pivot table friendly list

    I wrote a macro for a general purpose solution

    Capture.JPG
    Attached Files Attached Files
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  6. #6
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,844
    Quote Originally Posted by Paul_Hossler View Post
    I have to do something like that all the time
    Paul, are you able to gain access to my linked-to file? I ask because the OP says he can't.

  7. #7
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,711
    Location
    Accessed it with no problems

    Maybe the OP didn't noticed that the Logon screen had a 'No thanks, Continue to view' option ???
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

  8. #8
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,844
    Quote Originally Posted by Paul_Hossler View Post
    Accessed it with no problems
    Thanks Paul.

Posting Permissions

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