| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to re-group the cells from vertical to horizontal
Hi, I have a table like this:
column A(category) column B(items) Fruit Apple Fruit Orange Fruit Lemon Drinks Tea Drinks Coffee Snacks Candy Snacks Chips Snacks Chocolate And I want to change the format of the table to column A(category) column B(item 1) column C(item 2) column D (item 3) ..... Fruit Apple Orange Lemon Drinks Tea Coffer Snacks Candy Chips Chocolate Is there any formula to do this? Your help is much appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to paste link from 4 vertical cells to 4 horizontal cells? | Excel Discussion (Misc queries) | |||
| Cutting and Pasting cells from horizontal to multi vertical column | Excel Worksheet Functions | |||
| Arrays - Horizontal or Vertical | Excel Worksheet Functions | |||
| Linking a horizontal set of cells to a vertical sets of cells | Charts and Charting in Excel | |||
| Vertical to horizontal | Excel Discussion (Misc queries) | |||
Threaded Mode
