通过链接将一张纸上的列转换为另一列 [英] Transpose column on one sheet to row on another, with linking
本文介绍了通过链接将一张纸上的列转换为另一列的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
任何帮助或建议不胜感激。
解决方案
请在工作表中选择A1:J1 B并输入:
= TRANSPOSE('工作表A'!A1:A10)
with Ctrl + Shift + 输入。 >
I have a column of data in say A1:A10 in worksheet A. In worksheet B I have a range for data from A1:J1. I need the data from the column in worksheet A to be transposed into the data range in worksheet B. I can Paste Special and paste in the values but I need the information in worksheet A to update automatically that in worksheet B.
Any help or advice is appreciated.
解决方案
Please select A1:J1 in worksheet B and enter:
=TRANSPOSE('worksheet A'!A1:A10)
with Ctrl+Shift+Enter.
这篇关于通过链接将一张纸上的列转换为另一列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文