Join Dennis Taylor for an in-depth discussion in this video Transpose row/column into column/row layouts, part of Excel 2016: Cleaning Up Your Data.
- In this worksheet called Transpose,…I've started to build list here…of important contacts within this organization,…I need to reach these people often,…I need some information about them.…And the list will grow a little bit from time to time,…I'm thinking I'll have a few more names…in another few months,…maybe a few more.…After a while I begin to realize…that possibly this layout isn't the best.…Now I will be adding some more categories here,…so the list might also grow this way as well as this way,…but at some point, maybe the thought occurs,…could this data have been entered better…if we had put the employee name with the heading,…and then employee names underneath it.…
Then the list could grow substantially more,…than we're currently seeing,…and it'd probably be more readable.…Well, we don't want to reinvent the wheel,…we don't want to retype all this information,…but we can transpose it,…and that in no way destroys this,…but it might give us a better view of the data.…So let's simply highlight this data here and copy it.…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Moving and inserting rows and columns of data with a simple drag
- Replacing data at the character level
- Converting dates with text functions
- Converting text data to values
- Using the CONCAT and TEXTJOIN functions to combine data
- Splitting data into columns via the Text to Columns feature
- Using Flash Fill for faster combining and splitting
- Checking and correcting spelling mistakes