![]() ![]() On selecting the transpose option, your dataset gets copied in that cell range starting from cell G10 to M112.Transpose (As mentioned in the below screenshot) You must then select the 4 th option, i.e. When you enable right-click on the mouse, the paste option appears.Select the cell where you want to paste this data set, i.e.Copy the selected cells by pressing Ctrl + C.all the cells with the dataset in a spreadsheet. Here we need to convert its orientation from columns to rows with the help of a paste special option in excel. The below-mentioned Pharma sales table contains the medicine product code in column C (C10 to C16), quantity sold in column D (D10 to D16) & total sales value in column E (E10 to E16). ![]() You can download this Convert Columns to Rows Excel Template here – Convert Columns to Rows Excel Template Example #1 TEXT and String Functions in Excel (26+).Lookup and Reference Functions in Excel (35+). ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |