problem using replace function in sql

Hi i'm new programming in sql, i need to replace several values of the same column using the replace function but renaming the column to create new columns.The original columns look like this:

Estudent Type
estudent 1 REG
estudent 2 REP
estudent 3 DD


estudent n REG

And i need to retrieve the data like this:

Estudent REG REP DD
estudent 1 *
estudent 2 *
estudent 3 *


estudent n *

If anyone can figure out a way to do this(probably is easy but i can't figure out how) using replace or another way, i'll appreciate it, thanks!

NOTE: the format dosn't look good here, but the idea is to make a table with the asteriscs in the right position