How do i convert row array into one column using pivot table
ups sry (sry i no it isent pivot, but maby u can use it anyway)
=INDIRECT(CHAR(60+ROW())&2)
"Harry" skrev:
I do not understand after "Char"
"excelent" wrote:
if ur value is in A2,B2,C2,D2 and so on
=INDIRECT(CHAR(60+RÆKKE())&2)
"Harry" skrev:
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?
|