However, if inherited formatting is all that is putting you off, make the appropriate adjustments to the ‘Paste Special’ dialog box before pressing ‘OK’ / ENTER, e.g.
If the data needs to be linked to the source, then this approach is probably inappropriate. Aside from the inherited formatting, the main disadvantage here though is that depending upon the nature of the source data and how it is copied, updates in the original data will not flow through to the destination range. Step 1: select data in Excel Step 4: Home tab, in the clipboard group, click Paste and then click Transpose Step 3: Write (without quotes) followed by. Before getting started, you realize that you have to rearrange the data for the desired output. Suppose you receive a spreadsheet with lots of data for working.
#Excel formula to transpose data how to
This is an ideal approach for copying and transposing data from one source to another where links are not required. Excel TRANSPOSE Function (Table of Contents) TRANSPOSE in Excel TRANSPOSE Formula in Excel How to Use the TRANSPOSE Function in Excel TRANSPOSE in Excel. As can be plainly seen from the illustration (above), the formatting as well as the content will be transposed. You can use this function to transpose a vertical cell range where the data runs down the rows of adjacent columns to one where the data runs across the columns of adjacent rows and vice versa. the top left hand corner) of the intended range and Paste Special, Transpose ( ALT + E + S + E + ENTER). In Microsoft Office Excel 365, no need to enter the TRANSPOSE formulas as an array formula (Ctrl+Shift+Enter) as it spills to the neighboring cells.
In this instance, simply highlight the data and copy the range in the usual way (e.g.