| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Transpose Cell Contents
I have data in this format about the subjects that students take
Student A Student B Student C Student D Math Yes No Yes No Science No No Yes Yes Arts Yes Yes No No English Literature No Yes Yes Yes I want the data to be represented in this fashion: Student A Math Arts Student B Arts English Literature ......... Any suggestions on this? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to place the cell contents separated by a comma byinserting a new line and then copying the contents | Excel Programming | |||
| Is there a way to place the cell contents separated by a comma byinserting a new line and then copying the contents | Excel Programming | |||
| concatenate contents of cells whose contents resemble cell referem | Excel Worksheet Functions | |||
| Transpose cell contents from multiple worksheets into rows | Excel Worksheet Functions | |||
| How do I make a cell's contents equal to another cell's contents with macro program? | Excel Programming | |||
![RB[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
