How to distribute rows in excel with same data?

W

weranda2019-09-21 09:57:07

excel

weranda, 2019-09-21 09:57:07

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?

Reply

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.

Similar questions

P

pcdesign2021-02-13 13:40:00

Where to get i18n for Excel formulas? 1Reply

D

Damir Davletov2017-02-15 19:39:18

How to count columns in exel and insert them separated by commas? 1Reply

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

L

LightSid2017-02-17 15:06:07

How to export all days from analytics? 1Reply

Didn't find what you were looking for?

Ask your question