Hi all! Big fan of the forum, hope I can get a little assist on this pesky problem.

So I have a sheet with 200 URLs in column A. Each URL has 5-20 "keywords" in the columns next to it.

From an SEO standpoint, often times I'd like to utilize keywords with the MOST word count "design courses online" vs. just "design"

I've frozen column A. Is it possible for EACH row to be sorted where the cell w/ the most words in that row is first (column B) then it's sorted by descending order after that?

I've tried several workarounds/transposing setups, but I can't get it down.

Anybody know how to sort this doc so that keyword cells are arranged by word count for each URL?

here are several screenshots of my embarrassing performance thus far:

transposed: http://screencast.com/t/7HGSLOfepy
raw: http://screencast.com/t/XJNqJLQ1RnxM
word count under it: http://screencast.com/t/zEcXpVzv