Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need some help with Arrays
I'm trying to get the data from this format:
MNO Sort ZONES IN SORT PROGRAM 23 80011 80011, 80042 47 80012 80012, 80041 53 80013 80013 33 80014 80014, 80044 To this Format: MNO Sort ZONES IN SORT PROGRAM 23 80011 80011 23 80011 80042 47 80012 80012 47 80012 80041 53 80013 80013 33 80014 80014 33 80014 80044 So that each of the comma delimeted items in the last column is split out to it's own row, with the MNO and the Sort listed for each of the split items. Any ideas? Thanks Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trouble with arrays (transferring values between two arrays) | Excel Programming | |||
Working with ranges in arrays... or an introduction to arrays | Excel Programming | |||
Arrays - declaration, adding values to arrays and calculation | Excel Programming | |||
Arrays | Excel Discussion (Misc queries) | |||
Need help with arrays (I think) | Excel Programming |