Stuck with Table Manipulation in Query Editor

Hi,   Im trying to change around a table in query editor in a specific way and cant quite get it right, hopefully someone can point me in the right direction.   So my table is all text and format...