Excel behaving as if it were two tables

%3CLINGO-SUB%20id%3D%22lingo-sub-2724483%22%20slang%3D%22en-US%22%3EExcel%20behaving%20as%20if%20it%20were%20two%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2724483%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20an%20Excel%20document%20from%20two%20other%20Excel%20documents%2C%20but%20they%20will%20not%20sort%20across%20the%20'invisible%20boundary.'%20They%20are%20the%20same%20width%2C%20and%20have%20the%20same%20fields%20but%20they%20sort%20in%20two%20groups.%20Any%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2724483%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2724573%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20behaving%20as%20if%20it%20were%20two%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2724573%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F675292%22%20target%3D%22_blank%22%3E%40geoteach337%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20seeing%20the%20actual%20spreadsheet%2C%20relying%20solely%20on%20your%20description%2C%20one%20can%20only%20hypothesize.%20You'd%20have%20to%20do%20the%20testing%20of%20any%20hypothesis.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20one%20hypothesis%20is%20that%20you%20copied%20and%20pasted%20the%20one%20table%20adjacent%20to%20the%20other%20(perhaps%20even%20removing%20column%20headings%20from%20the%20second)%2C%20but%20left%20them%20as%20Table1%20and%20Table2%20(or%20whatever%20names%20had%20been%20assigned%2C%20if%20any)......so%20although%20the%20look%20to%20the%20human%20eye%20as%20a%20single%20table%2C%20Excel%20doesn't%20%22see%22%20them%20that%20way.%3C%2FP%3E%3CP%3EIF%20that%20fits%2C%20then%20you%20need%20to%20somehow%20help%20Excel%20%22see%22%20differently.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20try%20(just%20now)%20to%20replicate%20what%20you've%20described--creating%20two%20small%20tables%2C%20identical%20rows%20and%20columns%2C%20and%20then%20copying%20and%20pasting%20together--they%20are%20treated%20as%20a%20single%20table%20and%20sorted.%20It's%20only%20if%20I%20leave%20a%20blank%20row%20between%20them%20that%20they're%20not.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20have%20to%20ask%20if%20it's%20possible%20for%20you%20to%20post%20the%20spreadsheet%20if%20it%20persists%20in%20not%20sorting%20as%20one.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2729918%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20behaving%20as%20if%20it%20were%20two%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2729918%22%20slang%3D%22en-US%22%3EI%20did%20an%20aggressive%20component%20copy%20and%20paste%20into%20a%20new%20document%20and%20it%20seemed%20to%20have%20cleared%20any%20kind%20of%20weird%2C%20bogus%20Microsoft%20code%20that%20had%20infected%20this%20file.%20I%20wish%20it%20was%20properly%20coded.%3C%2FLINGO-BODY%3E
Occasional Contributor

I have created an Excel document from two other Excel documents, but they will not sort across the 'invisible boundary.' They are the same width, and have the same fields but they sort in two groups. Any ideas?

4 Replies

@geoteach337 

 

Not seeing the actual spreadsheet, relying solely on your description, one can only hypothesize. You'd have to do the testing of any hypothesis.

 

So one hypothesis is that you copied and pasted the one table adjacent to the other (perhaps even removing column headings from the second), but left them as Table1 and Table2 (or whatever names had been assigned, if any)......so although the look to the human eye as a single table, Excel doesn't "see" them that way.

IF that fits, then you need to somehow help Excel "see" differently. 

 

When I try (just now) to replicate what you've described--creating two small tables, identical rows and columns, and then copying and pasting together--they are treated as a single table and sorted. It's only if I leave a blank row between them that they're not.

 

So I have to ask if it's possible for you to post the spreadsheet if it persists in not sorting as one.

I did an aggressive component copy and paste into a new document and it seemed to have cleared any kind of weird, bogus Microsoft code that had infected this file. I wish it was properly coded.

@geoteach337 wrote: I did an aggressive component copy and paste into a new document and it seemed to have cleared any kind of weird, bogus Microsoft code that had infected this file. I wish it was properly coded.

 

I'm not even sure what you mean by some of what you've written. What, for example, I "an aggressive component copy and paste"? 

 

Anyway, it's also not clear if you're still seeking help. If so, can you post a copy of the material in question?

Hi. A copy and paste of the whole file into another Excel file did not correct the error, so I broke it up into parts, the header, some sectionalised into columns, and some sectionalised into rows, to get the errant code to reset, and it seems now to behave in a compliant way. That's what aggressive cutting and pasting means! Thanks for your help. Problem, for now, solved. Best, Andrew

@mathetes