A
A
Ayli_Y2021-01-31 16:15:50
excel
Ayli_Y, 2021-01-31 16:15:50

How to bulk duplicate cells?

There is a table in which you need to duplicate the numbers of transport orders and the name of the carrier with the following structure:
6016ade4b4b02573175302.png
There is a lot of data because it makes no sense to use hands.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander, 2021-01-31
@Ayli_Y

D2 is set equal to A2.
D3:
=IF there is a value in A3
THEN take A3
ELSE take D2.
Well, lots of checks.
Further themselves.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question