How do i convert row array into one column using pivot table

[Guest]

I am trying to convert 15 cells in a row into a single column of data using
pivot table function without much success. Has anyone have a way of doing
this?

 

[Guest]

if ur value is in A2,B2,C2,D2 and so on

=INDIRECT(CHAR(60+RÆKKE())&2)


"Harry" skrev:

 

[Guest]

I do not understand after "Char"

if ur value is in A2,B2,C2,D2 and so on

=INDIRECT(CHAR(60+RÆKKE())&2)


"Harry" skrev:

 

[Guest]

ups sry (sry i no it isent pivot, but maby u can use it anyway)


=INDIRECT(CHAR(60+ROW())&2)



"Harry" skrev:

 

[Guest]

what does "&2" do?

ups sry (sry i no it isent pivot, but maby u can use it anyway)


=INDIRECT(CHAR(60+ROW())&2)



"Harry" skrev: