Join Dennis Taylor for an in-depth discussion in this video Transposing data and charts for a different perspective on your data, part of Excel Tips Weekly.
- In this worksheet we see a list of names…in columns B, C, D, et cetera.…Imagine this list having been setup…when the organization was relatively small,…and over time it's growing.…Now we can certainly see all the information…about Edward Hayes right here, and Erik Pratt right here…and so on, we see what's happening here.…But as we start to scroll rightward…we see more and more names.…This is going to become unwieldy the more names we add,…not easy to read, and it certainly would have made…a lot more sense to say, why don't we take,…for example, all this employee name type information here…and put it in a column instead of a row.…
So imagine if we were putting this down in row 10,…we'd see employee names Hayes, Edward;…Mercado, David; Pratt, Erik; and so on down here,…and then here we'd see the departments and so on.…Now, after you've gone so far with this you're thinking…I don't want to reinvent the wheel,…I don't want to retype all this.…We can simply take this data and transpose it.…It's very similar to the same concept, if you are familiar…
Skill Level Appropriate for all
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.