Can You Solve This, By Using Transpose, Skip Blanks and Sorting Options ?

Today, I am going to explain you a Cool Trick to Transpose more than one Column Data into Single Row.

See the below case, and Try Your Own.

Did you get any Clue??


OK. Let me give you Few Clues..you can use Sort Option, Transpose Option and Skip Blanks Option

Still Not getting any Clue??