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

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?

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

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?

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

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?

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?

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

what does "&2" do?

"excelent" wrote:

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?