Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel tip
Hi all,
after I bit of a tip on manipulating an Excel file The data is as follows. Column 1 contains numbers; Column two contains a string of "labels" separated by "&"; Column three contains an integer that is a count of the number of labels. I wish to tranpose the labels into a 2nd column with the numbers in the first column. Raw data 1234 "fish"&"dog" 2 12356 "cat" & "mouse" 2 1374 "goat"&"horse"&"man" 3 Desired result 1234 fish 1234 dog 12356 cat 12356 mouse 1374 goat 1374 horse 1374 man Thanks Dave |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) |