This answer uses the data from How to convert row format data
into column format?, which was closed as a duplicate of this question.
So, this answer *does* answer this question, with trivial modifications
(i.e., ignore the parts of this answer that talk about data labels.

First of all, I’ll assume that your data are what you *appear* to be saying:

Create a new sheet
and enter column headings that correspond to your three data labels:

(You can do this by copying cells `A1:A3`

from `Sheet1`

and transposing them,
but, for just three, it’s probably easier just to type them in manually.)
Now, note that,
every time you move one cell (i.e., one column) to the right on `Sheet2`

,
that corresponds to moving down one row on `Sheet1`

.
And every time you move one row down on `Sheet2`

,
that corresponds to moving down three rows on `Sheet1`

.
So, guess that `=ROW()*3 + COLUMN()`

might be a useful formula,
and enter that into cells `A2:C4`

:

Note that the values progress in the way that we want them to.
But we want `Sheet2!A2`

to get its value from `Sheet1!A1`

,
so let’s subtract 7 and use the result as an offset.
Enter

```
=OFFSET(Sheet1!$A$1, ROW()*3+COLUMN()-7, 0)
```

into cells `A2:C4`

:

which is the data that you want, but with the data labels still attached.
So, to fix that, change the formula to

```
=SUBSTITUTE(OFFSET(Sheet1!$A$1, ROW()*3+COLUMN()-7, 0), A$1 & ": ", "")
```

to strip the label (from row 1 off the current column) from the cell data:

and then you can copy and paste values.

istransposition. – Ignacio Vazquez-Abrams Mar 8 '12 at 2:21nearlya dupe but since the data is positioned differently, I'm not sure about closing it. – Raystafarian Mar 8 '12 at 11:42