transposing multiple records (sort of)
Posted by anno on November 15, 2001 8:41 PM
i have about 700 records in a spreadsheet, each arranged in two columns, consisting of text entries (column b)against 9 categories (column a). the same 9 categories appear for each record but not all categories in each record have text against them. there is one row between the end of one record and the start of the next record. my problem is that each record is arranged like this:
...and i need all the text entries from each record arranged into columns under the existing headings (ie. SITE, NAME, etc)so i end up with the information in 9 columns and 700 rows. i know i could record a macro for 'copy|paste special|transpose' but i'd like to avoid having to do that for each record, and would prefer a non-vba solution (but i am open to any suggestions).
i hope this makes sense. i remember seeing similar questions to this before but can't find them on this page or either of the archives.
thanks in advance