View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RA RA is offline
external usenet poster
 
Posts: 53
Default 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?