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 |
All times are GMT +1. The time now is 10:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com