However, if you make changes to the original set of data, it will not be reflected in the transposed data since it’s just a copy. The data will not be linked, so you can safely delete the original set of data if you like. The easier way to transpose data in Excel is to use the copy and paste feature. This also means that if you delete the cells or rows of original data, you’ll get a reference error in the transposed cells! If you don’t want the two sets of data linked, the better option is to use the copy and paste method below, which duplicates the data rather than links it. I went ahead and changed one name and the hours worked for all the individuals and as you can see, both sets of data are synced. I used the transpose function to transpose the data. In the example below, I have some data on workers, hours worked and total pay. Even if the cells have formulas, it will update the values in both places. This means that if you change the data in A1, for example, it would change the value in A12 too. When you use the transpose function to transpose data, both sets of data are linked. Oddly, you cannot type the braces in yourself you must use the Ctrl + Shift + Enter key combination. This tells Excel that the formula’s output will be an array of data rather than just a single cell. The Ctrl + Shift + Enter key combination put a set of braces around the formula. Your Excel worksheet should now look like this: You need to hold down the Ctrl and Shift keys when you hit Enter. Entering this formula into Excel differs from most other formulas. Now type the following formula into the formula bar =transpose(a1:b6)īut don’t hit Enter yet. Make sure the area you selected is still selected before you start typing the formula. With this area selected, click on the formula bar above. Notice that the cells we chose include A12 to F13, a 6×2 area.

Where is transpose button in excel