How to display data from multiple columns in 1 column?

V

V

Vitaly Sadetdinov2019-09-06 16:58:30

excel

Vitaly Sadetdinov, 2019-09-06 16:58:30

How to display data from multiple columns in 1 column?

Connoisseurs, please help
https://docs.google.com/spreadsheets/d/1KTdaHKSrTa...
It is necessary to find unique values from all columns and display them in 1 column on a new sheet
and output for each unique value how many times it repeats

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

akelsey, 2019-09-06
@akelsey

Dig to the side:
TRANSPOSE
UNIQUE
COUNTIF

Similar questions

K

Konstantin Dashkevich2017-02-15 23:19:15

How to add an image to an Excel document by placing it under a specific cell? 1Reply

A

andreystrelkov2015-02-14 19:05:10

How can I copy-sparse a table / price from a site in Excel? 1Reply

M

MisTFoR2021-02-19 09:17:48

How to erase a word up to a certain character in Excel? 3Reply

I

Ivan Medvedev2020-03-04 08:06:16

How to make several page layout options depending on the value of a variable? 2Reply

S

sfalimov2017-02-27 10:40:06

How to assign weight to cells in OpenOffice Calc? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question