Column to text

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello, I have created a matrix and am attempting to link my column B with my Row 27. For example column B3 would read Robert and Row 27 C would also read Robert, column B4 would read Stan and Row 27 E would also read Stan - similar to a milage chart, I want to get the text entered in the column B3, B4, B5, etc to instantly appear in row 27, column D, E, F, etc. In Row 28 I would like a total of the column to appear.

Any help would be appreciated.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Not sure what you are asking

It seem all you have to do on c27 add formula

=IF(b3="", "", B3)