how can i create a sql to split data from a single column into 2 columns as below

col 1

Y
Y
N
N

into

Col A Col B

Y N
Y N

Thanks for your help.
Anan