| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table | Excel Discussion (Misc queries) | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Add a column outside pivot table and... | Excel Discussion (Misc queries) | |||
| pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
| Pivot table column duplicates | Excel Discussion (Misc queries) | |||
Linear Mode
