| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sub to transform table into cols
Source table is in sheet: V, cols A across to D ... ,
col headers in row1, data from row2 down, viz Cust# Visit01 Visit02 Visit03 ... Visit200 Cust001 Date01 Date03 Cust002 Date01 Cust003 Date03 Date04 Date05 Cust004 <blank 'no visits data as yet for this cust Cust005 Date05 etc In a new sheet, I would like to make a simple 3 cols table (cols A to C) from what's in V, ie: Cust# Date Visit# Cust001 Date01 1 Cust001 Date03 2 Cust002 Date01 1 Cust003 Date03 1 Cust003 Date04 2 Cust003 Date05 3 Cust004 <blank <blank Cust005 Date05 1 etc Appreciate your insights & help on a sub to achieve the above, guys. Thanks. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Table Transform | Excel Discussion (Misc queries) | |||
| Transform a table | Excel Programming | |||
| Range.Select 1st pass 13 cols, 2nd paqss 25 cols twice as wide in error? | Excel Programming | |||
| Transform table | Excel Programming | |||
| Cond Format:re color 2 cols, skip 2 cols | Excel Worksheet Functions | |||
Threaded Mode
