Unpivot with PowerQuery possible?

I'm not even sure if unpivot is the function that I would have to use to get my results. Here is how my powerquery table is laid out currently:
ColumnA (Name) Column B (Tier)
Dog Tier 1
Cat Tier 1
Pig Tier 1
Cow Tier 2
Bird Tier 2
Fish Tier 3
Bear Tier 3
Deer Tier 3

This is what I would want the result to be:

Column A (Tier 1) Column B (Tier 2) Column C (Tier 3)
Dog Cow Fish
Cat Bird Bear
Pig Deer

Is this possible in PowerQuery?

Edit: I attached a workbook since it's hard to do the spacing in the post.

Thanks for the help.

If you reorganize source table it will be possible.

pq.jpg

Formula:

Please Login or Register  to view this content.

in PQ select Tier, then Pivot then Name

TIP: if you want to show text values as text you can't count/sum/average etc. these values