Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
i have data in a pivot table form put not defined as a pivot table
i would like to be able to have excel transpose the data into record form if any one has suggestions and wants sample data please reply |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
To reorganize the data, you can use the technique described here by John
Walkenbach: http://j-walk.com/ss/excel/usertips/tip068.htm If you have multiple label columns, you should concatenate them before using the above technique. For example, insert a blank column after Product Name, with a heading, and the formula: =A2 & "$" & B2 After using the technique, use DataText to Columns, Delimited, to split the data into separate columns. Robin Krupp wrote: i have data in a pivot table form put not defined as a pivot table i would like to be able to have excel transpose the data into record form if any one has suggestions and wants sample data please reply -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Pivot table formats text data with 2 decimals | Excel Discussion (Misc queries) | |||
Excel Pivot Table Appends a '2' to the field data items | Excel Discussion (Misc queries) | |||
Pivot Table Data Filter Problem | Excel Discussion (Misc queries) | |||
Pivot Table Data Field Query | Excel Worksheet Functions |