=OFFSET($A$1,(ROW()-1)*4+INT((COLUMN()-3)),MOD(COLUMN()-3,1))įill this formula across to column F, and then down to row 3.Īdjust the column sizes as necessary. Select the first cell where you want to paste the data, and on the Home tab, click the arrow. Using the Cut command or CONTROL+X won’t work. Note: Make sure you copy the data to do this. In a new worksheet, type the following data: Here’s how: Select the range of data you want to rearrange, including any row or column labels, and either select Copy on the Home tab, or press CONTROL+C. This is a similar scenario as that which you experience when you open a worksheet or text file that contains data in a mailing label format. ![]() The following example converts every four rows of data in a column to four columns of data in a single row (similar to a database field and record layout). On the Home tab, in the Clipboard group, select the Paste list and then choose Transpose (T): Clipboard group in Excel 2016 Right-click and choose Transpose (T). When you use the Microsoft Excel products listed at the bottom of this article, you can use a worksheet formula to covert data that spans multiple rows and columns to a database format (columnar).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |