How to expand excel spreadsheet row by row?

E

Evgeny Mikhailov2020-10-21 11:56:41

Macros

Evgeny Mikhailov, 2020-10-21 11:56:41

There is a table in Excel similar to this

What to do to convert the data into strings in the form,

Arkhangelsk - Astrakhan | 2625
Arkhangelsk - Barnaul | 4664
Arkhangelsk - Belgorod | 1884
etc.

Reply

Answer the question

In order to leave comments, you need to log in

2 answer(s)

C

ComodoHacker, 2020-10-21
@ComodoHacker

For example, write two nested loops in VBA.

K

Kirilkin, 2021-02-07
@Kirilkin

You can use a simple macro in the Table Designer.
https://www.planetaexcel.ru/techniques/3/55/
For similar tasks, he helped me before