Forum Discussion

Patrick002320's avatar
Patrick002320
Copper Contributor
Jun 08, 2023

How can I combine data from multiple columns & rows into one row/column

Hello everyone,   I have never done this before and I am very new to excel but I have a table of data about monthly temperatures for each year. In the A column I have all the years from 1961-2023 a...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 08, 2023

Patrick002320 

As variant, if on Excel 365

=VSTACK(
    {"Year"," Month","Temperature"},
    HSTACK(
        TOCOL(IF(SEQUENCE(, 12), Tabelle1[Year])),
        TOCOL(
            IF(
                SEQUENCE(ROWS(Tabelle1)),
                Tabelle1[[#Headers],[January]:[December]]
            )
        ),
        TOCOL(Tabelle1[[January]:[December]])
    )
)

Resources