+ Reply to Thread
Results 1 to 3 of 3

Stacking Columns in Excel

  1. #1
    Registered User
    Join Date
    04-30-2011
    Location
    Indian, TN
    MS-Off Ver
    Excel 2007
    Posts
    37

    Stacking Columns in Excel

    Hi All,

    Please help me with the desired result wherein I am requiring to stack all columns after column A & B, under these columns A & B along with the standard data in each column.

    I am attaching an excel file with the data in sheet 1 named Data and the desired result in the sheet 2 named Result. Please review and advise.
    P.S: There is no specification on the result to be displayed in another sheet, we can have a code that does this task on same sheet itself.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,520

    Re: Stacking Columns in Excel

    here's one way

    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.

  3. #3
    Registered User
    Join Date
    04-30-2011
    Location
    Indian, TN
    MS-Off Ver
    Excel 2007
    Posts
    37

    Re: Stacking Columns in Excel

    Thank you so very Mike, the above code worked like a charm.

    Thanks again,
    Sanjay

+ 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