| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ALIGN DATA CELLS?
I have a table like:
Column A Column B Column C Column D Store 1 Store 2 Store 3 Store 4 ============================ Dunhill Marlboro Dunhill Kingston Marlboro Camel More Marlboro Camel More Camel Dunhill More Kingston Could there be a way to arrange the data to be showing similar items on the same row? For Instance: Column A Column B Column C Column D Store 1 Store 2 Store 3 Store 4 ============================ Camel Camel Camel Dunhill Dunhill Dunhill Kingston Kingston Marlboro Marlboro Marlboro More More More An appropriate array formula or preferably a VBA code shall be highly obliged. Thanx! -- Best Regards, FARAZ A. QURESHI |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Align matching cells of two different columns | Excel Worksheet Functions | |||
| Left align '$' and right align numbers? | Excel Discussion (Misc queries) | |||
| how to align vertical cells horizontally | New Users to Excel | |||
| How do I align cells in Excel onto one line? | Excel Worksheet Functions | |||
| What is short-Cut forleft align and Right align? | Excel Discussion (Misc queries) | |||
Threaded Mode
