Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reformat a worksheet using a macro
I would appreciate some help on this one, if anyone can help.
I have an exported CSV file that I need to format in a more legible manner using Excel. The file lists some dates in one row after another and I would like all of the dates to be in one row for each property. At the moment it looks like this: CustomerID Service NoAccess 21 19/05/2003 20/04/2004 21 19/05/2003 07/05/2004 21 19/05/2003 20/05/2004 21 19/05/2003 02/09/2004 27 10/03/2004 17/02/2005 27 10/03/2004 08/03/2005 What I would like to see is this. Customer ID Service No Access 21 19/05/2003 20/04/2004 07/05/2004 20/05/2004 02/03/2004 27 10/03/2004 17/02/2005 08/03/2005 etc etc Even if someone can give me a starter I can try and go with that, but my VBA skills are rusty. Cheers Andrew H |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reformat dates | Excel Discussion (Misc queries) | |||
Cell Reformat | New Users to Excel | |||
now() reformat in spreadsheet | Excel Worksheet Functions | |||
Reformat spreadsheet | Excel Worksheet Functions | |||
Reformat Table | Excel Discussion (Misc queries) |