Excel Tricks – Data

Transpose data from a row to a column, or vice-versa The best solution under the Paste Special menu. Start by selecting and copying your entire data range. Click on a new location in your sheet, then go to Edit | Paste Special and select the Transpose check box. Click OK, and Excel will transpose the … Continue reading Excel Tricks – Data