Reference data to another Sheet in the current sheet, and then transpose
[Users questions | Browse:36 | Favorites]
Users questions: There is a performance table, the original data in sheet1, the vertical lines A1, A2, A3 ... A7 is the same person's name, rampant B2 to B7 is the name of the person the subject, E2 to E7 is the person's performance, then each seven-line is another person's examination subjects and results. Now intend to sh eet2 column shows the name of A, B2 to H2 subjects subjects display the name, following the rampant display performance, how to quickly apply the data in sheet1 and then transpose?
Experts answer: taking into account the upstairs Prophet answered, when the number of students a lot, you enter a list of all students, rather Trouble, and when the students have the same name, an error results, so I'll give you an option. Specific annex. Attachment: transpose (1). Xls
Experts answer: taking into account the upstairs Prophet answered, when the number of students a lot, you enter a list of all students, rather Trouble, and when the students have the same name, an error results, so I'll give you an option. Specific annex. Attachment: transpose (1). Xls
- There are several new methods of presentation, simply out of.
- What word in how to increase the special symbols
- excel how to filter and distinguish between the number of consecutive
- How will the characters in the cell and breakdown of figures show?
- How to set excel in the integer "0" format
- How to convert PDF text editable word or TXT
- How could such a problem?
- Help explain, EXCEL function of usage, there are accessories.
- Why not let me see My Network Places?
- EXCEL delivery table and more, how do
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.