Break the Lines

Hi Team,

Seeking a help here !!!

I have some data which comes in one single row, wanted to break and group the details as per the output as shown below:

i have also attached the test data for your reference. Can you please help me on this.

Raw data :

Name Block DATE Country Vehicle Type Name Block DATE Country Vehicle Type Name Block DATE Country Vehicle Type Name Block DATE Country Vehicle Type
AAA 4 04-13-1993 India 2 BBB 2 04-11-2015 India 2 CCC 3 02-11-2019 India 4 DDD 5 07-09-1993 India 2

Name Block DATE Country Vehicle Type
AAA 4 04-13-1993 India 2
BBB 2 04-11-2015 India 2
CCC 3 02-11-2019 India 4
DDD 5 07-09-1993 India 2

Please Login or Register  to view this content.

Does this macro do what you want...

Please Login or Register  to view this content.

Kamalakar M

Do you need vba for this?
Formula A4
=A1 then copy to E4

Formula in A5
=IFERROR(INDEX($A$2:$T$2,1,(ROW(A1)-1)*5+COLUMN(A1)),"")
copy to E5 then copy A5:E5 down

vba

Please Login or Register  to view this content.

Thanks a lot Rick.

the solution was perfect. Thanks again