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 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.