and then delete your original column by right-clicking the column header. Using this method ensures the data remains in the same order, and you haven't had to use any formulas in the process. You can ...
To hide multiple rows or columns, press and hold the CTRL key while selecting them. Alternatively, you can go to Format > Hide & Unhide in the Home tab and select Hide Rows or Hide Columns. The column ...