How do I group rows in an excel table?
I'm creating an excel table to keep a tab of patients' payments made on their visits. The problem I am having is that some patients have multiple visits so they have multiple rows in the table, but I don't have their name listed repeatedly. So for example, their name is listed in A1, and their visits are listed in D1 and D2, but their name is not listed again in A2. When I try and sort or filter the table, only the visit listed in D1 gets sorted with the patient name. How do I get these grouped together to where if I sort alphabetically, the multiple visits (rows) get sorted too? I have included a picture of the problem. Thank you!
PivotTable : Unexpected behavior with 2 tables
Hi, The first picture shows the expected behavior of adding 'Product' and 'Revenue' to a pivot table. Now when i add the same fields but from 2 different tables linked with a relationship, the result is different (please see 2nd picture). Could somebody explain this weird behavior ? Thanks in advance PivotTable with 1 table PivotTable with 2 tables RelationshipDelete row/column including table row/column
I've been searching the internet for quite a while now to find an answer to the following: I would like to know whether it is possible to delete an entire row/column which also is part of a table. If I try this now, the error message appears: 'it is not possible to delete this row/column now'. Hope that there is a genius who knows an answer to this riddle. Johan.
Copying table into docx makes page numbering go haywire
Hello, So, context: I'm working on a doctoral thesis. I have a table, which was originally created in LaTeX, which I originally copied into my thesis as an image. The thesis office wasn't happy with it being an image, they wanted it as a text-form Word table. Long story short, through great and valiant effort, my advisor and I got it converted to a text-form Word table. Basically the last thing I have to do to get my thesis cleared is get this damned table pasted into my thesis. But when I attempted to do so, behold - it completely screwed up the page numbering of my entire thesis. It changed everything so that the following page became page 1, and the preceding pages no longer had page numbers. The table itself was a standalone file in the other docx - and I tried explicitly turning off all headers, footers, and page numbers in that file, to no avail when re-pasting. I accosted an agent on Microsoft support chat, who resolved the issue, and I should have just stopped him right there, but he kept messing with my document and messed up his own fix. He ultimately gave up and sent me here. I was really hoping to include file attachments to demonstrate the issue but this interface doesn't appear to allow it. If anyone could offer me a workaround for that, I would appreciate that as well. Thanks in advance for any assistance you can offer. Cheers, Matthew Lockner
