+ Reply to Thread
Results 1 to 4 of 4

Problem with a table.

  1. #1
    Registered User
    Join Date
    11-07-2021
    Location
    Fairhope, AL
    MS-Off Ver
    2013
    Posts
    2

    Problem with a table.

    Greetings,

    I was given a spreadsheet to make an attempt to improve on it.

    This table in it has 7 columns of 40 possible entries.

    I want to add a way to sort this table. The only problem is the first 3 columns need to be separated from the other 4.

    I have looked into many ways that I thought might do this, but I have came up dry.

    Is there a quick and easy way to do this? Or should I just rebuild the table?

    Thanks,
    Royce

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Problem with a table.

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    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
    Registered User
    Join Date
    11-07-2021
    Location
    Fairhope, AL
    MS-Off Ver
    2013
    Posts
    2
    Quote Originally Posted by alansidman View Post
    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    Sorry, i knew that but thought i could explain. I should have known better.

    I will post back when i can get back to my computer.

    Thanks Again,
    Royce

  4. #4
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Problem with a table.

    About sorting 2 or more columns:

    https://support.microsoft.com/en-us/...a-dc37d4515f27

    What do you mean with "the first 3 columns need to be separated from the other 4."?

+ 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: 6
    Last Post: 07-01-2018, 01:58 PM
  2. [SOLVED] Problem Copying Table Column to Another Table
    By snapfade in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2017, 07:45 PM
  3. Replies: 6
    Last Post: 01-24-2017, 06:56 PM
  4. Pivot table problem - how to relate 3 sheets' data into 1 pivot table?
    By GRG Stevan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-14-2015, 06:12 AM
  5. add to table problem
    By mcmpr in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 09-04-2008, 09:02 AM
  6. Look up table problem
    By shannoncox in forum Excel General
    Replies: 3
    Last Post: 11-30-2006, 09:43 AM
  7. data table problem
    By trixma in forum Excel General
    Replies: 5
    Last Post: 10-10-2005, 03:54 AM

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