Postgres 10

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table test (option1 varchar, option2 varchar, option3 varchar);
insert into test values('1','A','X');
insert into test values('1','B','Y');
insert into test values('2','A','X');
insert into test values('3','B','Y');
insert into test values('3','A','X');

CREATE TABLE

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

select distinct 
unnest(array['option1','option2','option3']),
unnest(array[option1,option2,option3])
from test
order by 1,2

unnest
unnest

option1
1

option1
2

option1
3

option2
A

option2
B

option3
X

option3
Y

SELECT 7

select distinct t2.*
from test t1
  cross join lateral (
     values 
       ('option1',t1.option1 ),
       ('option2',t1.option2),
       ('option3',t1.option3)
       
  ) as t2(option, value)
order by 1,2

option
value

option1
1

option1
2

option1
3

option2
A

option2
B

option3
X

option3
Y

SELECT 7