| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format excel data
Hi All,
I am having the hierarchial data in the excel in the following format.. ---------------------------------------------------------------------------------------------------------------------- Column A Col B Col C Column D ---------------------------------------------------------------------------------------------------------------------- Airwick Freshmatic TOTAL Air Care Czech Republic France Germany Great Britain Greece Hungary Italy Netherlands Poland Portugal Airwick Mobil'Air COMPLETE Air Care Italy Netherlands TOTAL Air Care Czech Republic Greece Hungary Portugal ---------------------------------------------------------------------------------------------------------------------- I need the output in the following format.. i.e the data need to be updated from the cell above which have the value.. ---------------------------------------------------------------------------------------------------------------------- Col A Col B Col C Column D ---------------------------------------------------------------------------------------------------------------------- Airwick Freshmatic TOTAL Air Care Czech Republic Airwick Freshmatic TOTAL Air Care France Airwick Freshmatic TOTAL Air Care Germany Airwick Freshmatic TOTAL Air Care Great Britain Airwick Freshmatic TOTAL Air Care Greece Airwick Freshmatic TOTAL Air Care Hungary Airwick Freshmatic TOTAL Air Care Italy Airwick Freshmatic TOTAL Air Care Netherlands Airwick Freshmatic TOTAL Air Care Poland Airwick Freshmatic TOTAL Air Care Portugal Airwick Mobil'Air COMPLETE Air Care Italy Airwick Mobil'Air COMPLETE Air Care Netherlands Airwick Mobil'Air TOTAL Air Care Czech Republic Airwick Mobil'Air TOTAL Air Care Greece Airwick Mobil'Air TOTAL Air Care Hungary Airwick Mobil'Air TOTAL Air Care Portugal ---------------------------------------------------------------------------------------------------------------------- Can anyone please help me in writing some macro to get the desired output. Regards Param |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing Data from Excel when data not in same format | Excel Discussion (Misc queries) | |||
| format data displayed on Excel data entry form | Setting up and Configuration of Excel | |||
| Excel data file format | Excel Discussion (Misc queries) | |||
| How do I put Excel data into a US map format? | Charts and Charting in Excel | |||
| Excel Data Format | Excel Programming | |||
Threaded Mode
