W
W
weranda2019-09-21 09:57:07
excel
weranda, 2019-09-21 09:57:07

How to distribute rows in excel with same data?

Greetings.
There are two tables on one sheet. They have one identical field. How can I make fields with the same names appear on the same line, and fields with missing names appear below the table?5d85c99b176d0557581851.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
P
Pychev Anatoly, 2019-09-21
@pton

Look at the VLOOKUP function.
The alternative is a macro.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question