pivot table - Excel PivotTable; how to show values horizontally -

i'm trying rearrange pivot table organizes values (not sum or other statistic) original table. seems simple can't find way make values rather sums.

my original data looks like:

rank    name 1       1       b 2       c 2       d 3       e 3       f

and pivot table like:

rank  name 1               b 2       c         d 3       e         f

and rearrange so:

1          2            3          c            e b          d            f

there's way achieve using array functions instead of pivot tables. suppose original data located in a1:b7. headers row (1, 2, 3):

a10: =min(a2:a7) b10: =small($a$2:$a$7,countif($a$2:$a$7,"<="&a10)+1)

then copy b10 far right need other values

to values each rank, set array formula (ctrl+shift+enter) on range a11:a16 (or lower fit more items) formula:

=iferror(index($b$2:$b$7,small(if($a$2:$a$7=a$10,row($a$2:$a$7)-row($a$2)+1),row()-row(a$10))),"")

then copy range (a11:a16) far right need...

Braziel