S
sbitaxi
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
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