+ Reply to Thread
Results 1 to 10 of 10

Transpose Columns To Rows

  1. #1
    Forum Contributor
    Join Date
    05-19-2015
    Location
    Karnataka, INdia
    MS-Off Ver
    MS Office 2010
    Posts
    277

    Transpose Columns To Rows

    Hi,

    I need help to move Couple of Columns only to Rows result in order to have a tale prepared.

    Headers - ID Country Customer Brewer Brand SubBrand OuterPackage InnerPackage ContainerVolume SKU Year Month Sales Sales_Promo Units Units_Promo Volume Volume_Promo
    Value - 306 BE Intermarche BR.ROMAN ABD.VAN_ENAME BLONDE NA 6 X 0033.0 CL ABD.VAN_ENAME_BLONDE_BOUT_CAUT_6 X_0033.0 CL 2014 Apr 64 0 10 0 19.7 0

    I need only couple of Headers to come to rows field like below

    Measure Country Customer Brewer Brand SubBrand OuterPackage InnerPackage ContainerVolume SKU Year Apr

    Sales BE Intermarche BR.ROMAN ABD.VAN_ENAME BLONDE NA 6 X 0033.0 CL ABD.VAN_ENAME_BLONDE_BOUT_CAUT_6 X_0033.0 CL 2014 64
    Sales_Promo BE Intermarche BR.ROMAN ABD.VAN_ENAME BLONDE NA 6 X 0033.0 CL ABD.VAN_ENAME_BLONDE_BOUT_CAUT_6 X_0033.0 CL 2014 0
    Units BE Intermarche BR.ROMAN ABD.VAN_ENAME BLONDE NA 6 X 0033.0 CL ABD.VAN_ENAME_BLONDE_BOUT_CAUT_6 X_0033.0 CL 2014 10
    Units_Promo BE Intermarche BR.ROMAN ABD.VAN_ENAME BLONDE NA 6 X 0033.0 CL ABD.VAN_ENAME_BLONDE_BOUT_CAUT_6 X_0033.0 CL 2014 0
    Volume BE Intermarche BR.ROMAN ABD.VAN_ENAME BLONDE NA 6 X 0033.0 CL ABD.VAN_ENAME_BLONDE_BOUT_CAUT_6 X_0033.0 CL 2014 19.7
    Volume_Promo BE Intermarche BR.ROMAN ABD.VAN_ENAME BLONDE NA 6 X 0033.0 CL ABD.VAN_ENAME_BLONDE_BOUT_CAUT_6 X_0033.0 CL 2014 0

  2. #2
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Transpose Columns To Rows

    Hi Biplab,

    it would be great if you provide sample workbook with desire output.
    Thanks - Naveed
    -----------------------------
    If the suggestion helps you, then Click * to Add Reputation
    To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
    1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

  3. #3
    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,917

    Re: Transpose Columns To Rows

    Often, a copy/paste of data to here, doesnt come out quite as expected - this is 1 of those times

    To Attach a File:

    1. Scroll down to the window below your post Additional Options
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.
    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

  4. #4
    Forum Contributor
    Join Date
    05-19-2015
    Location
    Karnataka, INdia
    MS-Off Ver
    MS Office 2010
    Posts
    277

    Re: Transpose Columns To Rows

    Hello,

    Thanks for your reply. I have attached the sample data workbook with two worksheets - Exported data and Desired output.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    05-19-2015
    Location
    Karnataka, INdia
    MS-Off Ver
    MS Office 2010
    Posts
    277

    Re: Transpose Columns To Rows

    Please let me know if you need anything else.

  6. #6
    Forum Contributor
    Join Date
    05-19-2015
    Location
    Karnataka, INdia
    MS-Off Ver
    MS Office 2010
    Posts
    277

    Re: Transpose Columns To Rows

    Any input?

  7. #7
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Transpose Columns To Rows

    Hi Biplad,

    find check attached file and let us know is it what you are looking for ? i hope this will meet your expectation

    Note: In exported data sheet all columns should be same place like there in attached file

    Please Login or Register  to view this content.
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    05-19-2015
    Location
    Karnataka, INdia
    MS-Off Ver
    MS Office 2010
    Posts
    277

    Re: Transpose Columns To Rows

    Thanks a lot, Exactly what i was looking for.

    I have some concerns though, The exported data has 640000 records, Would not the final output be huge in excel in that case?.

    That is the reason i used access DB to have the raw data stored. Is there anyway i could incorporate this in access VB module.
    Let me know. This step is only to normalize the data, I also have to get 16 more calculated columns based on the VALUE column(In your output). Let me know if excel worksheet can handle this data.

  9. #9
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Transpose Columns To Rows

    Hi Biplab,

    okay, is it possible you to provide a sample access db file

  10. #10
    Valued Forum Contributor Naveed Raza's Avatar
    Join Date
    11-04-2012
    Location
    India, Hyderabad
    MS-Off Ver
    Excel, Access 2007/2010
    Posts
    1,338

    Re: Transpose Columns To Rows

    Hi Biplab

    please find attached MSAccess file with query for your output.

    Fill the Exported Data in Exported_Data table

    just save this attached file and open it and double click on "QueryFor_FinalOutput" you will get your desire output

    i am unable to attached Access File and if you IM me your email id then i will forward you

+ 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. Replies: 4
    Last Post: 01-26-2015, 03:08 PM
  2. [SOLVED] Formula to transpose rows to new columns and columns to new rows in Excel
    By bjnockle in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-26-2014, 06:28 PM
  3. Replies: 1
    Last Post: 01-24-2014, 06:20 PM
  4. Replies: 14
    Last Post: 08-01-2013, 08:48 AM
  5. [SOLVED] Transpose Columns to Rows (automatically inserts new rows)
    By kichkichkich in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-28-2012, 05:38 AM
  6. Replies: 2
    Last Post: 01-01-2012, 05:54 AM
  7. Transpose Columns To Rows (with Variable Columns)
    By G.HendriX in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-08-2011, 08:40 PM

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