Excel Forum
Similar Content
Filter Data in Excel to Show Only the Top X Percent of that Data Set - AutoFilter
Macro: This Excel macro filters a set of data in Excel and displays only the top X percent of tha...
Quickly Switch the Columns and Rows of a Data Set in Excel
Tutorial: How to switch a data set in Excel so that the columns become rows and the rows become col...
Filter Data Sets on Multiple Columns with Multiple Criteria at Once in Excel - AutoFilter
Macro: This Excel macro allows you to filter a data set on multiple columns and criteria at once....
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Excel Magic Trick 644: Recorded Macro And Formulas To Re-Arrange Data Set


See how to create a Recorded Macro that uses formulas to rearrange a proper data set to one listed in a column. Learn about:
1. Relative References in a Recorded Macro
2. Formulas to join data in the middle of a Recorded Macro
3. CHAR(1) function to add word wrap in a formula
4. Where to locate selected cells during a Relative Reference Recorded Macro.





Got a Question? Ask it Here in the Forum.