How to get alternate column data from Excel sheet

  1. Add a row as first row and add numbers in columns as 1,2,1,2 etc.
  2. Then highlight your entire range of data.
  3. Go to Data menu -> select Sort and Options…
  4. Change your Orientation to “Sort Left and Right”.
  5. Choose row 1 as sort by and Smallest to Largest. Excel will be changed with alternate column data with columns which have 1, followed by columns which have 2

About the Author


A passionate blogger. Love to share solutions and best practices on wordpress hosting, issues and fixes, excel VBA macros and other apps

Leave a Reply

Your email address will not be published. Required fields are marked *