Sort data with multiple header rows?
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]
Want to read more?
Check out the full article on the original site