excel -how do you change the row order of data in a column into different row positions based upon 1 cell...
up vote
0
down vote
favorite
Edited question to hopefully make clearer.
I have a worksheet which uses formula to import data (Football results) from another worksheet,within the workbook, which show's column data in a specific row order.
Column a / row 1 - a1 - is a specific football team name
column b - row 1 informs if the game is H or A - Home or away (this is determined if a1 matches either b2 or b5)
b2 - shows away team name
b3 - shows the home team result
b4 - shows the away team result
b5 - shows home team name
I want to show in b6 the result of the team named in a1 - irrespective of it being H or A game, and then in b7 the result of the opposing team - again irrespective of it being a H or A game - keeping the data in b1 to b5 unchanged.This would then be applied to subsequent games played in adjacent columns.
Thanks for any help offered.
microsoft-excel
asked Nov 26 at 23:34
Bryan
11
add a comment |
up vote
0
down vote
favorite
Edited question to hopefully make clearer.
I have a worksheet which uses formula to import data (Football results) from another worksheet,within the workbook, which show's column data in a specific row order.
Column a / row 1 - a1 - is a specific football team name
column b - row 1 informs if the game is H or A - Home or away (this is determined if a1 matches either b2 or b5)
b2 - shows away team name
b3 - shows the home team result
b4 - shows the away team result
b5 - shows home team name
I want to show in b6 the result of the team named in a1 - irrespective of it being H or A game, and then in b7 the result of the opposing team - again irrespective of it being a H or A game - keeping the data in b1 to b5 unchanged.This would then be applied to subsequent games played in adjacent columns.
Thanks for any help offered.
microsoft-excel
asked Nov 26 at 23:34
Bryan
11
1
Too hypothetical. Please give an example. Please do not respond in comments; edit your question to make it clearer and more complete.
– Scott
Nov 27 at 0:10
Yes is true that you have not presented the questions properly. Better share some sample data & the expected output, will help us to fix the issue. ☺
– Rajesh S
Nov 27 at 9:54
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
Edited question to hopefully make clearer.
I have a worksheet which uses formula to import data (Football results) from another worksheet,within the workbook, which show's column data in a specific row order.
Column a / row 1 - a1 - is a specific football team name
column b - row 1 informs if the game is H or A - Home or away (this is determined if a1 matches either b2 or b5)
b2 - shows away team name
b3 - shows the home team result
b4 - shows the away team result
b5 - shows home team name
I want to show in b6 the result of the team named in a1 - irrespective of it being H or A game, and then in b7 the result of the opposing team - again irrespective of it being a H or A game - keeping the data in b1 to b5 unchanged.This would then be applied to subsequent games played in adjacent columns.
Thanks for any help offered.
microsoft-excel
asked Nov 26 at 23:34
Bryan
11
Edited question to hopefully make clearer.
I have a worksheet which uses formula to import data (Football results) from another worksheet,within the workbook, which show's column data in a specific row order.
Column a / row 1 - a1 - is a specific football team name
column b - row 1 informs if the game is H or A - Home or away (this is determined if a1 matches either b2 or b5)
b2 - shows away team name
b3 - shows the home team result
b4 - shows the away team result
b5 - shows home team name
I want to show in b6 the result of the team named in a1 - irrespective of it being H or A game, and then in b7 the result of the opposing team - again irrespective of it being a H or A game - keeping the data in b1 to b5 unchanged.This would then be applied to subsequent games played in adjacent columns.
Thanks for any help offered.
microsoft-excel
microsoft-excel
asked Nov 26 at 23:34
Bryan
11
asked Nov 26 at 23:34
Bryan
11
edited Nov 27 at 20:30
asked Nov 26 at 23:34
Bryan
11
asked Nov 26 at 23:34
Bryan
11
asked Nov 26 at 23:34
Bryan
11
11
1
Too hypothetical. Please give an example. Please do not respond in comments; edit your question to make it clearer and more complete.
– Scott
Nov 27 at 0:10
Yes is true that you have not presented the questions properly. Better share some sample data & the expected output, will help us to fix the issue. ☺
– Rajesh S
Nov 27 at 9:54
add a comment |
1
Too hypothetical. Please give an example. Please do not respond in comments; edit your question to make it clearer and more complete.
– Scott
Nov 27 at 0:10
Yes is true that you have not presented the questions properly. Better share some sample data & the expected output, will help us to fix the issue. ☺
– Rajesh S
Nov 27 at 9:54
1
1
Too hypothetical. Please give an example. Please do not respond in comments; edit your question to make it clearer and more complete.
– Scott
Nov 27 at 0:10
Too hypothetical. Please give an example. Please do not respond in comments; edit your question to make it clearer and more complete.
– Scott
Nov 27 at 0:10
Yes is true that you have not presented the questions properly. Better share some sample data & the expected output, will help us to fix the issue. ☺
– Rajesh S
Nov 27 at 9:54
Yes is true that you have not presented the questions properly. Better share some sample data & the expected output, will help us to fix the issue. ☺
– Rajesh S
Nov 27 at 9:54
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1378588%2fexcel-how-do-you-change-the-row-order-of-data-in-a-column-into-different-row-po%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
Too hypothetical. Please give an example. Please do not respond in comments; edit your question to make it clearer and more complete.
– Scott
Nov 27 at 0:10
Yes is true that you have not presented the questions properly. Better share some sample data & the expected output, will help us to fix the issue. ☺
– Rajesh S
Nov 27 at 9:54