It’s simple, when you edit your header in Site editor, you can click on header and choose to replace header. Then, select transparent header. You can select sticky option on header group and add position absolute class. Make sure that you have some padding in block below header. It’s not required to use transparent header for sticky option, you can use also sticky option on regular header. Check video.