Sort data with multiple header rows?
Our take
Hi everyone!
I am trying to see if it's possible for me to sort data in a sheet that has multiple header rows.
The sheet is tracking orders in different statuses, I have it separated for the New orders in the top section, then row 11 starts those that have had initial attention, but not fully in progress, on row 25, I have a header row for those who are fully in progress, etc
The purpose of the separation is because there is different information I have to keep track of for each of these statuses, but I don't want to have them in different sheets because it's so helpful to be able to refer to them all in one spot.
I'm hoping to be able to alphabetically sort customer names and also sort by dates, but the date columns are not uniform throughout the different statuses.
If anyone knows if this is possible, help would be so appreciated!!
Nevermind everyone! I figured it out by highlighting each section and inserting a table with headers! Leaving this here and marking as solved in case it helps someone!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Sort by multiple headers at once?I'm doing a database for a client, a little out of my wheelhouse, and I'm super rusty at Excel, want to make sure I'm doing it efficiently. The key part is his client list, customer wants to be able to sort by multiple values at once. For example, he wants to know which of his clients are the longest-lasting, who orders the most often, who orders the highest value, and who fits all three of those criteria. There's a few other fields involved, but that's the main feature he wants. submitted by /u/Xuncu [link] [comments]
- Is it possible to create a custom sort order?This is more of a curiosity than a problem I HAVE to solve, so it's not essential if I don't get a solution! I have some data that I wish to sort, but rather than 1-10 or A-Z, I need it to do a specific order. Is this possible? Ai Up Ye Un No EDIT: I know that I could just put the number in front of the words, basically like I have done here and than sort numerically. It just looks a bit clunky, and also I have very narrow column for this info as I need the whole sheet to fit on the screen and be legible. submitted by /u/BoudaSmoke [link] [comments]
- How To Group Multiple Rows?Hoping someone has a good tip for this. I have an excel sheet with 14,035 rows of data and 466 columns of data. Many rows share a common order number or common address. What is the best excel feature to group these rows and maintain all 466 columns? I’d like a heirarchmal grouping if possible, first by order number then by address. I’ve tried Power Query, get from Table but I can’t quickly convert this much data into a table. We have customers with multiple address booked under a single order number - order number is at the customer level. at each address there may be multiple products. I need a way to quickly answer these types of questions… -How many customer order numbers are there? -What % of address locations have XYZ mix of products? -How many address locations have multiple products? and what are the products? -What is the age of the individual products? submitted by /u/Impossible_Equal_642 [link] [comments]
- Is there a way for me to sort dates found across multiple columns into another set of columns and have the original column headers next to each sorted dates?I have a sheet that details my farming activity schedules. Each row represents individual plot of land (LandID#), while columns represents each farming activities (eg. seeding, thinning, pot-up, transplant, and removal). As I input the seeding date, all the other activity dates are populated. As I am growing many different types of crops, the quantity of varying dates is large. Using this sheet alone, makes it very difficult and tiring just to figure out what activity is next on schedule. I'm hoping that there is a way to present these dates in a manner that is more intuitive. Perhaps presenting these into 3 columns: Date, Activity, and LandID#. Then having the data sorted ascendingly by date. Or perhaps there is a better idea. Thanks in advance! submitted by /u/mtgoni [link] [comments]