Formula to change vertical items to horizontal items - Repeated values - New2

[Vignesh Veerasamy]

Hi Gurus

Thanks for support regarding the post earlier done.
One query is needed as below
Based on the position of "-" check column data to be updated as below format.
Thanks.

 

[bosco_yip]

Try,

In G2, formula copied down :

=IFERROR(MATCH("-",B2:F2,0),"No data")

 

[Vignesh Veerasamy]

Try,

In G2, formula copied down :

=IFERROR(MATCH("-",B2:F2,0),"No data")

View attachment 80456

Thank you @Bosco about the special case : PartDDE will same formula work?