As pictured this new list view has the column headers that are un-clickable, so one can't sort by clicking on the column headers.
Why is the Finder doing this and how do I get it back to the way it is in the deactivated window.
You could also select View > Arrange By > None, press ⌃⌘0, or change the arrange mode from the pop-up menu on the toolbar.
This new different list view is a result of the fact that Apple added a new way to organize and visualize files in a folder in Lion as noted in a article by MacYourself - How to arrange and sort files in Finder using Mac OS X Lion. As a result there is some confusion.
Lion’s new way of arranging and sorting in Finder
In previous versions of Mac OS X, the Arrange By function in Finder simply changed the order in which files and folders were displayed based on the user’s selection. In OS X 10.7 Lion, there are two ways to sort: Arrange By and Sort By. Arrange By now groups files and folders into categories.
An arragement is set on the list view and that is why the directory looks abnormal. To re-enable column header that can sort one needs to first un-set the currently selected arrangement.
A way to stop the arrangement of a list view:
While in a Finder window with an arrangement set, select the "View" drop down menu on the menu bar and select "Show View Options" or type Command+ J
Under Arrange By: pop-up menu select "None".
Now the Finder window should have the clickable column headers as expected in a list view.