I'm checking for values with a string field of NULL.You'll either want to change your sheet names or the code Look at what I named the sheets: Original and Normalized. ![]() You'll need to put this code in a code module in VBA (the same place where Macros go).Here are a few things you should know about my code. Let's look at a possible solution in VBA. ![]() To make sure that formulas continue to refer correctly to data in nontransposed cells, use absolute references in the formulas before you transpose them.įor more information, see Switch between relative, absolute, and mixed references. Tip If the cells that you transpose contain formulas, the formulas are transposed and cell references to data in transposed cells are automatically adjusted. Make sure that you select a cell in a paste area that falls outside of the area from which you copied the data.Ĥ.On the Home tab, in the Clipboard group, click the arrow below Paste, and then click Transpose.ĥ.After the data is transposed successfully, you can delete the data in the copy area. After you copy cells, a moving border appears around them to indicate that they've been copied.) and paste areas (paste area: The target destination for data that's been cut or copied by using the Office Clipboard.) cannot overlap. Note Copy areas (copy area: The cells that you copy when you want to paste data into another location. ![]() To complete this procedure successfully, do not use the Cut command.ģ.On the worksheet, select the first cell of the destination rows or columns into which you want to rearrange the copied data. Note You can only use the Copy command to rearrange the data. Keyboard shortcut To copy the selected data, you can also press CTRL+C. To rearrange data from rows to columns, select the cells in the rows that contain the data.Ģ.On the Home tab, in the Clipboard group, click Copy. ![]() To rearrange data from columns to rows, select the cells in the columns that contain the data. If data is entered in columns or rows, but you want to rearrange that data into rows or columns instead, you can quickly transpose the data from one to the other.įor example, the regional sales data that is organized in columns appears in rows after transposing the data, as shown in the following graphics. It's pretty hidden and a bit clumsy but likely easier than delving into VBA. Excel has a transpose feature which may address your needs.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |