B
B
Beksultan Asanov2021-07-26 16:12:48
excel
Beksultan Asanov, 2021-07-26 16:12:48

How to reduce values ​​in EXCEL in the form of a ladder into one line?

There are 28 thousand such values, how can this process be automated?
60feb4b120e60388498094.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
H
hint000, 2021-07-26
@donororgazm0v

Too lazy to strain your brains, so here's a simple option:
1) add a new column between the first and second.
2) let's say the value 12886 is in cell A1, then we write in B1 the formula =IF(A1="";"";C2)
(I have LibreOffiice in the screenshot)
3) drag the formula down
4) hide column C (do not delete)
5) repeat for the remaining columns by analogy
60feba39d4c69600386795.png

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question