How to arrange text in excel columns?

D

Damian Lewis2020-07-04 15:36:37

excel

Damian Lewis, 2020-07-04 15:36:37

There is a certain order of data (about 1000) located one after another. For example Name and link under it. It is necessary that the link stands opposite the name, as in the screenshot. How to automate this process?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

H

hint000, 2020-07-04
@DamianLewis

How to automate this process?

It depends on what is considered automation.
Stand in B1, press =A1, stand in C1, press =A2, highlight from B1 to C3 and drag down to hide column A. Done.
Is this considered automation or not?