Rearranging data
I currently receive a file that has a persons ID # and then a list of work
skill #s they have been assigned. I need to have that data modified.
EX: the data comes to me in this format
12345 100 101 110 52
12346 99 191 45 17
12347 150 101 52 99
I need the data to come out in this format:
12345 100
12345 101
12345 110
12345 52
12346 99
12346 191
12346 45
12346 17
12347 150
Etc.
I have dozens of lines long and when converted will be hundreds of lines
long. Any ideas?
|