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

H

Harry

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?
 
E

excelent

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

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


"Harry" skrev:
 
E

excelent

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


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



"Harry" skrev:
 
Top