Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Rearranging DATA | Excel Discussion (Misc queries) | |||
Rearranging data | Excel Discussion (Misc queries) | |||
rearranging data | Excel Worksheet Functions | |||
Rearranging the layout of data | Excel Discussion (Misc queries) | |||
Rearranging Data Help... | Excel Discussion (Misc queries) |