+ Reply to Thread
Results 1 to 3 of 3

Multiple Rows As One Table Row

  1. #1
    Forum Contributor
    Join Date
    09-13-2012
    Location
    Midwest
    MS-Off Ver
    Excel 365
    Posts
    124

    Multiple Rows As One Table Row

    So I have my file setup as the image below. I'm keeping it simple so it can be edited with a phone. But I go through many, many of these in a week, and I'd like to be able to make this into a table so I can simply sort/filter. But it seems like I cannot have multiple rows behave as a single table row (single table row being where the thick borders are). Anyone know otherwise? It'd be hugely convenient, and I cant believe this isnt a table option yet. Thank you.
    Capture.JPG

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,757

    Re: Multiple Rows As One Table Row

    In order to have this converted to a table, you will need to eliminate all merged cells. Merged cells create more issues with data manipulation. They do not allow data to be normalized so that you can extract needed data through filters or queries.
    Alan


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Forum Contributor
    Join Date
    09-13-2012
    Location
    Midwest
    MS-Off Ver
    Excel 365
    Posts
    124

    Re: Multiple Rows As One Table Row

    Thank you, I guess *sigh*

+ 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. [SOLVED] Formula to copy and paste multiple rows while skipping blank rows in the table
    By teton88 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-07-2018, 02:16 PM
  2. [SOLVED] Delete table rows in multiple table is specific range
    By 3345james in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-26-2017, 08:32 AM
  3. Getting Multiple Rows From a Table
    By Gobble in forum Excel General
    Replies: 4
    Last Post: 05-07-2017, 10:14 AM
  4. Pivot Table with multiple rows/sub rows
    By j_cole in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 08-01-2016, 07:05 AM
  5. Date Stamp within Excel table - Changes in multiple rows and columns and new rows added
    By jarheadmctavish in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 03-09-2016, 03:22 PM
  6. Return indexes of rows when multiple rows of a table are selected.
    By samkumar in forum Word Programming / VBA / Macros
    Replies: 0
    Last Post: 08-12-2013, 04:54 AM
  7. Replies: 1
    Last Post: 11-29-2012, 06:24 PM

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