![]() ![]() ![]() Select the range A4:E5 and replace all equal signs with xxx.ħ. Right click, and then click Paste Special.Ħ. 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.Ĥ. If blank, the IF function below returns an empty string (two double quotes with nothing in between) to transpose. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |