+ Reply to Thread
Results 1 to 4 of 4

Changing Horizontal data to Vertical

  1. #1
    Registered User
    Join Date
    12-08-2014
    Location
    houston, tx
    MS-Off Ver
    2013
    Posts
    1

    Changing Horizontal data to Vertical

    I want to change horizontal data into vertical. Data set is huge and i would need some VBA help.

    My data looks like this -

    Customer Product Market Jan/12 Feb/12 Mar/12....
    A 1 ox 100 200 50
    B 1 nox 30 20 10

    and i want the data to look like

    Customer product market month
    a 1 ox jan/12 100
    a 1 ox Feb/12 200
    a 1 ox Mar/12 50
    b 1 nox jan/12 30
    ...............

    any help will be appreciated.

    Thanks

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,377

    Re: Changing Horizontal data to Vertical

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Changing Horizontal data to Vertical

    try.. reverse Pivot...

    https://www.youtube.com/watch?v=N3wWQjRWkJc
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  4. #4
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Changing Horizontal data to Vertical

    Duplicate..

+ 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. Changing horizontal data to vertical
    By clockhart10 in forum Excel General
    Replies: 1
    Last Post: 11-07-2013, 03:39 AM
  2. Changing horizontal cell refernece to vertical
    By LFoote in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-28-2012, 05:30 PM
  3. Changing Horizontal to vertical references
    By Seriously in forum Excel General
    Replies: 5
    Last Post: 07-21-2010, 01:24 PM
  4. Changing entries from horizontal to vertical
    By greek in forum Excel General
    Replies: 3
    Last Post: 10-29-2009, 06:15 PM
  5. Replies: 6
    Last Post: 08-07-2007, 10:45 AM

Tags for this Thread

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