Transposing multiple individual records
Last answer on Mar 20, 2009 3:54:34 pm GMT Heather, on Mar 19, 2009 6:11:43 pm GMTHello,
I have data with each individual record split down multiple rows, followed by the next individual record.
Each has a unique record # in Column A and something I need to sort by in Column C, identical for each individual record (but several possibilities across records), but then in column F each record's information is listed down multiple rows.
Ideally I would sort first by column C then A, then what I have been doing is splitting the sorted info based on col. C into new wkshts.
Then I manually highlight the multiple rows of Col. F for each unique record number in Col. A, and use the transpose function, then delete unneeded columns.
I know there are more efficient ways excel can do at least parts if not all of this...
Thanks so much!
Configuration: Windows XP Internet Explorer 6.0
Can I set up a macro to transpose this data in Column C into a single row and multiple columns (rather than one column and multiple rows) for each unique record number repeated in Column A for all the rows of data for that record. For example:
|
Access vba undo create a record- Batch file rename multiple files
- Call of duty 4 key code multiplayer
- Content control software individual user
- Count individual records excel
- Creating "multiple folders" vista mkdir
- Dos rename multiple files
- Dvdfab record in full screen
- Free sound recorder software for xp
- How to make multiple if else statements in c
- How to record streaming video
- Macro split excel into multiple excel files
- Multiplayer code call of duty 4
- Online dj record music and play
- Select multiple records xl sheet
- Sony ic recorder mp3
- What is a computer that provides software and other resources to multiple computers over a network?
- Xp professional multiple install
