Part I is in general. Part II is for $((0,1),\mathscr B(0,1), Leb)$
Part I:
Skorokhod representation of a random variable $X$ with distribution $F_X$ in the probability space $(\Omega, \mathscr F, \mathbb P)$ is given by
$$X(\omega) = \sup\{x \in \mathbb R | F_X(x) < y\}$$
However, in $(\mathbb R, \mathscr B(\mathbb R), \mathbb P)$, its Skorokhod representation is simply the identity random variable:
$$X(\omega) = \omega$$
Part II:
TL;DR To get Skorokhod representation of $X$ in $((0,1),\mathscr B(0,1), Leb)$, just look up $X$'s quantile function $F^{-1}_X(x)$ and then change the parameter from $x$ to $\omega$. Why? Actually for the identity random variable $Y(\omega) = \omega$ in the probability space in $(*)$ in OP, $Y$ is uniform. That is, quantile functions refer to the probability space $((0,1),\mathscr B(0,1), Leb)$ because $((0,1),\mathscr B(0,1), Leb)$ for uniform is like $(\mathbb R, \mathscr B(\mathbb R), \mathbb P)$ is for exponential. Then probability integral transform states that $X = F^{-1}_X(Y)$. You can also look up 'Examples of the inverse transform sampling.' Try section 4.11 'Sampling from a distribution' in Grimmett and Stirzaker's Probability and Random Processes.
- By probability integral transform, the basis for Inverse transform sampling (hence the
NORMINV(RAND(),\mu,\sigma)), we have that for any $X$ and uniform $Y$,
$$X=F^{-1}_X(Y)$$
where $F^{-1}_X(y)$ is the regular inverse of cdf $F_X(x)$ if it's continuous otherwise generally:
$$F^{-1}_X(y) := \inf\{x \in \mathbb R | F_X(x) \ge y\}$$ and $y \in [0,1]$.
Convince yourself that $$\inf\{x \in \mathbb R | F_X(x) \ge y\} = \sup\{x \in \mathbb R | F_X(x) < y\}$$
Since uniform distribution's Skorokhod representation is the identity random variable $Y(\omega) = \omega$ in $((0,1),\mathscr B(0,1), \mu)$ where $\mu$ is Lebesgue, any random variable is its quantile function evaluated at a uniformly distributed random variable, i.e. evaluated at such $\omega$:
$$X=F^{-1}_X(Y):=\inf\{a \in \mathbb R | F_X(a) \ge Y\}$$
Conclusion? If you want Skorokhod representations, just look up quantile functions.
For example, to get the Skorokhod representation of a Bernoulli random variable $X$ with parameter $p$, look up its quantile to be
$$F_X^{-1}(y) = 1_{(p,1)}(y)$$
ETA: It seems Bernoulli here is $P(X=0)=p$ rather than $P(X=1)=p$
Conclude by probability integral transform:
$$X(\omega) = F_X^{-1}(\omega) = 1_{(p,1)}(\omega)\tag{*}$$
Wait, what's the difference between $y$ and $\omega$? $y$ has no distribution. It's just some number in $[0,1]$. Meanwhile, $\omega = Y(\omega) \sim Unif(0,1)$
Going back, we can verify $(*)$ by proving that
$$1_{(p,1)}(\omega) = \sup\{a \in \mathbb R | (1-p)1_{[0,1)}(a) + 1_{[1,\infty)}(a) < \omega\}$$
and
$$1_{(p,1)}(\omega) \sim Be(p)$$
Btw, since it can be shown that $X(\omega) \sim $Be$(p) \iff X(1-\omega) \sim $Be$(p)$ (for $\omega \sim$ Unif$(0,1)$), we have not only that $1_{(0,1-p)}(\omega) \sim Be$ but also that
$$1_{(0,1-p)}(\omega) \sim Be(p)$$