Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have records of customers with names and address info as below in an excel sheet on column A:A: ================= Name of Customer A Adres of customerA Name of Customer B Adres of customerB ..... .... ... Name of Customer XY Adress of customer XY ========================= The number of lines used for the address info may vary from one customer to another. But there is at least one "empty" line between each customer. I also don't know the exact number of customers...It's a long list. I need to sort this list onto another sheet in the workbook, so that the names will reside under column A and corresponding address info's on column B. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting and coloring cells, formula or macro help needed | Excel Discussion (Misc queries) | |||
Chart For Every Row In Short Period/Easy Manner | Charts and Charting in Excel | |||
Formula or macro needed for sorting complex data issue. | Excel Discussion (Misc queries) | |||
Excel Macro to Modify Multiple Worksheets in the Same Manner | Excel Discussion (Misc queries) | |||
comapre two list of data & arranging in a same manner | New Users to Excel |