+ Reply to Thread
Results 1 to 9 of 9

Trouble Working with data. Trying to make it all flat

  1. #1
    Forum Contributor
    Join Date
    07-17-2009
    Location
    Raleigh, NC
    MS-Off Ver
    Excel 2013/2016
    Posts
    107

    Trouble Working with data. Trying to make it all flat

    I have this data that I exported from our XCart site. Some of the data is horizontal, but then the details are vertical.

    These columns are fine like they are: !ORDERID !ITEMID !PRODUCTID !PRODUCTCODE !PRODUCT !PRICE !AMOUNT !PROVIDER

    But then the Data in Column J needs to be horizontal, like Account Number Invoice Number Invoice Comments

    So I was trying to do it with a formula, but copying the formula didn't work at all.

    I'd really like to have a VB Script that did this for me, because the woman needs this done everyone month.

    Data attached.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    07-17-2009
    Location
    Raleigh, NC
    MS-Off Ver
    Excel 2013/2016
    Posts
    107

    Re: Trouble Working with data. Trying to make it all flat

    Does anyone have any help on this for me?

    Thanks.

  3. #3
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Trouble Working with data. Trying to make it all flat

    You can use this code -
    Please Login or Register  to view this content.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  4. #4
    Forum Contributor
    Join Date
    07-17-2009
    Location
    Raleigh, NC
    MS-Off Ver
    Excel 2013/2016
    Posts
    107

    Re: Trouble Working with data. Trying to make it all flat

    Thanks, I'll give it a whirl

  5. #5
    Forum Contributor
    Join Date
    07-17-2009
    Location
    Raleigh, NC
    MS-Off Ver
    Excel 2013/2016
    Posts
    107

    Re: Trouble Working with data. Trying to make it all flat

    Arlette,

    Where do I put that code? In a new sheet?

  6. #6
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Trouble Working with data. Trying to make it all flat

    Open your excel file. Press Alt+F11. It will open up a code window. On the left hand side, you will see Microsoft Excel Objects. Right click and select Insert -> Module. Copy the code over there.

    Go back to your excel file. Save it. Then go to Tools -> Macro -> Macros and run the macro.

  7. #7
    Forum Contributor
    Join Date
    07-17-2009
    Location
    Raleigh, NC
    MS-Off Ver
    Excel 2013/2016
    Posts
    107

    Re: Trouble Working with data. Trying to make it all flat

    Arlette,

    So this seems to work well, but what I'd like to do is have this script pull the data from another sheet instead of rearranging the data on the current sheet.

    How do I change the code to do that. The data is on a sheet called Data and the rebuilt data is on the Info Sheet.

  8. #8
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Trouble Working with data. Trying to make it all flat

    In which sheet do you need the output?

  9. #9
    Forum Contributor
    Join Date
    07-17-2009
    Location
    Raleigh, NC
    MS-Off Ver
    Excel 2013/2016
    Posts
    107

    Re: Trouble Working with data. Trying to make it all flat

    Output sheet is called Info

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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