| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
collapse rows into one
Each occurence of A has 20-30 rows of data appearing in columns B thru K. I
need to collapse all rows into one per each occurence of A. Value in A appears only once. For example: A2 = 035 B2 = abc c3 = def e4 = ghi k5 = jkl d6 = mno c7 = pqr b8 = stu I need to see 1 row: A B C D E F G H I J K 035 -abc -def -mno -ghi -jkl -stu -pqr How can I accomplish this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i expand and collapse rows | New Users to Excel | |||
| How do I collapse rows in Excel? | Excel Worksheet Functions | |||
| Collapse Rows? | Excel Discussion (Misc queries) | |||
| Expand/Collapse Rows | Excel Worksheet Functions | |||
| Collapse rows with duplicates | Excel Worksheet Functions | |||
Threaded Mode
