Thread: How do i convert row array into one column using pivot table
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
excelent excelent is offline
external usenet poster
  
Posts: 695
Default 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?
Reply With QuoteReply With Quote