Forum Discussion
Wardah Mustahsan
Oct 03, 2018Copper Contributor
Excel Sorting help
Hi I need a little help with sorting. In the sheet I attached below I have sorted A-K based on 96 plate level, KS###, and Y number. But my issue is that the 384 position has to be the same in eac...
Detlef_Lewin
Oct 03, 2018Silver Contributor
Hello
You have four separate tables which are separated by empty columns.
Solutions:
- Remove the empty columns and make sure every other column has a header text.
- Select the area over the four tables and klick on "Filter" or press CTRL-SHIFT-L.
- Add a header text in every empty cell in row 1.