0

I have an excel sheet with exactly 1 filled cell per row and column like this:

-------------
| 3 |   |   |
-------------
|   |   | 1 |
-------------
|   | 2 |   |
-------------

for which I want to create a "projection" row and column like so (the arrows denote the projection direction):

-------------       -----
| 3 |   |   |       | 3 |
-------------       -----
|   |   | 1 |  -->  | 1 |
-------------       -----
|   | 2 |   |       | 2 |
-------------       -----
      |
      v
-------------
| 3 | 2 | 1 |
-------------

any suggestions of how to accomplish that without resorting to VBA?

Improve this question
5
  • 1
    Welcome to Superuser! This will be easy with the latest version of Excel.
    – Reddy Lutonadio
    Commented Nov 17, 2023 at 6:32
  • @ReddyLutonadio could please share some information like what the earliest latest Excel version is that makes it easy and how it is done there (any commands or keywords to search for)? Thanks!
    – Manfred Weis
    Commented Nov 17, 2023 at 6:52
  • =SUM(range) ...
    – jsotola
    Commented Nov 17, 2023 at 7:02
  • @jsotola How will the SUM function accomplish what the OP is asking?
    – Reddy Lutonadio
    Commented Nov 17, 2023 at 7:08
  • @jsotola does that also work for non-numerical data like text or timestamps?
    – Manfred Weis
    Commented Nov 17, 2023 at 7:08

1 Answer 1

Reset to default
1

Disclaimer: The following functions are only available on Excel365.

Use TOCOL and TOROW functions to create your "projections" vertically and horizontally.

TOCOL

=TOCOL(A1:C3;1)

TOROW

=TOROW(A1:C3;1)

Improve this answer
1
  • Very helpful answer!
    – Manfred Weis
    Commented Nov 17, 2023 at 7:11

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .