Alter
The ALTER section is a hodge podge of various functions that help you change data. Watch the videos to see if any can help you.
- 01) Sort Selected Cells Based on up to 9 Columns
- 02) Sort Selected Cells Based on Text and Cell Color
- 03) Insert Row on Change
- 04) Remove Empty Rows From Selection
- 05) Paste Your Copied Cell and Skip the Blank Lines
- 06) Fill in The Blanks By Using The Value From The Above Cells
- 07) Convert Possible Dates Found Within Selected Cells to Either Text or Julian
- 08) Write label ‘EOT’ to select cells. Only populates blank cells.
- 09) Convert Asterisks to Dashes 123456*1 becomes 123456-1
- 10) Resets the Used Range for the Current Tab
- 11) Re Enter The Cells Value Allowing it to Pick Up the Underlying Format
- 12) Flip the Sign on Each Cell Within Selection
- 13) Transposes Data. Select the entire column(s) for the base data, then select the header cells. Will Remove Zeros and Blanks
- 14) Transposes Data. Select the entire column(s) for the base data, then select the header cells. Will Zeros Fill Blanks
- 15) Complex Data Fill In (VLOOKUP on Steroids)
Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc