Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I gather similarly structured data from about 30 different sources. These
data are in matrix format (15 rows by 23 columns). To be able to analyze the data with pivot tables, I want to convert them to a flat file format, with pr line the row label, column label, and value. What is the easiest way to do this? ( individually referring to each cell and it's row and column label is too error prone / tedious, as I need to be able to change the matrix format for every new version, which is about twice yearly, and as I have more than 1 matrix format, according to the type of source) -- Think, then move |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Repeated data into flat file format | Excel Worksheet Functions | |||
How to convert a Pivot Table into a Flat File format? | Excel Discussion (Misc queries) | |||
how do I convert an excel file to a flat text file | Excel Discussion (Misc queries) | |||
Convert excel file to flat text file | Excel Discussion (Misc queries) | |||
Convert excel file to flat text file | Excel Discussion (Misc queries) |