+ Reply to Thread
Results 1 to 7 of 7

Convert col to row in new tab, grouped by col heading

Hybrid View

  1. 10-28-2013, 06:37 AM #1
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Convert col to row in new tab, grouped by col heading

    A result sheet is one showing how you want your data to look like after the macro is run.
    Reply With QuoteRegister To Reply
  2. 10-28-2013, 08:00 AM #2
    sschinker
    sschinker is offline
    Registered User
    Join Date
    10-24-2013
    Location
    Billings, MT
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Convert col to row in new tab, grouped by col heading

    The 'Smpl Layout' file I'd previously attached had examples of two recipes on one tab. I modified the data to reflect the change on a 'New' tab. The 'Current' tab shows an example of the how the data is now. Please see the attached file 'Smpl Layout02' for results sheet.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Help! Convert data in Excel to FLAT file (header columns/value rows) from being GROUPED
    By talbottsw in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-11-2013, 04:42 PM
  2. Convert Vertical data to grouped horizontal Data
    By robot1 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-02-2012, 05:51 PM
  3. [SOLVED] Sub-heading stuck at same heading number
    By Hallet in forum Word Formatting & General
    Replies: 1
    Last Post: 06-01-2012, 08:16 AM
  4. Convert Data to columns heading
    By cheerboy555 in forum Excel General
    Replies: 2
    Last Post: 05-05-2006, 12:50 AM
  5. In a table produce an value by column heading and row heading
    By naflan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-27-2005, 01:25 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1