Rows to Colums Transpose with Condition

My data :

|A
B
C
D
E
|F
G
H
|I
|J
K
L
M
N
|O
P

Expected Data

|A B C D E
|F G H
|I
|J K L M N
|0 P

I need a macro to transpose rows into columns.
Whenever the cell has pipe "|" (e.g. |A, |F..) data should be entered in next row.

I have a macro that will transpose a row for every 7 rows, but I need macro that transposes till cell has "|" in one row and then continue to next row.

Please Login or Register  to view this content.

Kindly do the needful.

This may work

Please Login or Register  to view this content.

This may work

Please Login or Register  to view this content.