Create/ Calculate new example

Hi,

I have a data set like this:

Value | Nr.

X | 1

Y | 2

And like to have this kind of data set:

Question:

How can I generate new examples from the existing one? Do I need to use transpose to generate new Attributes? Or should I use De-Pivot or a Macro? What is the most effective way?

Thanks for help.

Peter