![]() The value in cell H3 will also change from 16 to 36. Note: for example, change the value in cell C2 from 16 to 36. Select the range G1:H5 and replace all occurrences of 'xxx' with equal signs (the exact opposite of step 6). Use ' Paste Special Transpose' to transpose this data.Ĩ. Select the range A4:E5 and replace all equal signs with xxx.ħ. And finally assign your keyboard shortcut. Right click, and then click Paste Special.Ħ. You would need to create a Personal Macro Workbook by recording a macro and using the option Store Macro In: Personal Macro Workbook and then paste this into it: Code: Sub Transpose () Selection.PasteSpecial Paste:xlPasteAll, Transpose:True End Sub. ![]() The ' Paste Special Transpose' option is a great way to transpose data but if you want to link the source cells to the target cells, you need a few magic tricks.Ĥ. ![]() Select the cell where you want the transposed data. Paste the data using the transpose command. If blank, the IF function below returns an empty string (two double quotes with nothing in between) to transpose. You can also select the data then use the Ctrl+ Ckeyboard shortcut to copy the data instead of using the ribbon commands. The TRANSPOSE function converts this blank cell to a zero (cell G3).Ģ. Simply use the IF function to fix this problem.ġ. The TRANSPOSE function in Excel converts blank cells to zeros.
0 Comments
Leave a Reply. |