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

M

mts20502016-01-01 20:15:32

Program or macro for information processing? 0Reply

N

Nikolai2017-01-09 22:33:16

How to map a column in a Power Query? 0Reply

S

spokinoki2017-01-11 10:00:49

Is there a script for the site through which it can upload an Excel file to the server and tell the sender if it is filled out correctly? 2Reply

V

Vitaly Petrov2015-01-25 16:58:43

SheetJS/js-xlsx and file formatting? 3Reply

P

Pavel Ragulin2019-06-27 15:21:37

Why is Excel throwing an error? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question