Join every 4 rows into one row into Excel file

Help
#1

Hello Guys,
I want to join every 4 rows into one row like this :

image
image881×422 6.87 KB

Row which has value Num =1 should have Propo A B C D … the same as the others

Any suggestions?
Best Regards

#2

@hhajar,

Do you want to merge the rows in the Excel?

1 Like
#3

@sarathi125 ,
yes , this is the output im looking for :

image

#4

@hhajar,

To build the logic I would like to know more about the data.

In the “Num” column if we have 1,2,3,4 then we should have “Propo” 4 sets only right?
Is there any condition to map 1 with ABCD and 2 with ABCD like that?

1 Like
#5

@sarathi125,

The condition is simply in each time you find lettre ‘A’ should be folowed by the 3 rows ‘B’ ‘C’ and ‘D’ and inserted beside Num ‘1’ and so on for the other Num column.