Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Parse row data in Excel
Hi everyone,
I am trying to separate data that has been entered into Excel from one row into multiple rows. The document has been used for planning activities, scheduled date and responsibility. These factors are all in separate columns, but are itemized within the cells. Each record has up to 10 activities (numbered 1 through 10) that relate to a scheduled date and responsiblity (both also numbered 1 through 10) within the same cell. Dates are in one column, responsibility in another. Is it possible to parse the records out into the 10 instances, as rows with the values in the other columns copied to keep the data consistent? A B C D 1 Poker Game 1. November 1. John Table 2. February 2. John 3. March 3. 4. June 4. Mary etc. In that case, I'd like to be able to convert it so it appeared as the following A B C D 1 Poker Game 1. November 1. John Table 2 Poker Game 2. February 2. John Table 3 Poker Game 3. March 3. Table 4 Poker Game 4. June 4. Mary Table Does that make sense? Is this possible? In some instances there are not a full 10 occurences, is there a way to account for this variable? Thanks for your help! (Note, it isn't really a poker schedule, but this was far simpler to present) S |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to parse column data only when text is present | Excel Worksheet Functions | |||
How to parse data | Excel Discussion (Misc queries) | |||
How to parse data | Excel Discussion (Misc queries) | |||
Parse Data to Various Columns | Excel Discussion (Misc queries) | |||
Parse data with uneven lengths and different delimiters | Excel Worksheet Functions |