Converting rows to columns?

Question

excel

Strings

01.01.2022 08:46:47  Продажа
Пост-2 АИ-92-К5
Банковские карты
500.00 руб.
10.32×48.4302=499.80
01.01.2022 10:51:34  Продажа
Пост-3 АИ-92-К5
Ведомость
30.00 л
30.00×47.25=1 417.50
Карта: 560
01.01.2022 12:56:17   Продажа
Пост-3 АИ-92-К5
Cкидка 3%
500.00 руб.
10.64×46.9925=500.00
Карта: 2180000104590
01.01.2022 14:34:07  Продажа
Пост-2 ДТ-З-К5
Ведомость
250.00 л
250.00×55.34=13 835.00
Карта: 27 б/н
Карта: 27 б/н

in such

Answer 1

You expel this "information" into bare text, regularly translate it into CSV suitable for import, fill it in.

Answer 2

42
question will be?

Answer 3

I'm going through the steps.
1. Insert the formula into cell B1 =A2. Insert the formula into cell C1 =A3. And so on until E1=A5.
2. Select cells B1-E1.
3. Double click on the small cube in the lower right corner of the selection. Entries will multiply down.
4. Without resetting the selection, click "Copy".
5. Without resetting the selection, click "Paste Special - Values".
6. Select column A. Execute Sort A to Z. Agree to auto expand the range.
7. Select and delete all lines that do NOT start with a date.
Everything.
If you need to do it regularly - record a macro. The lines to be deleted are then found by searching (for example, by the word "Sale").