Combine rows of text - while maintaining the original column positions

[Craig Monty]

Hi, I hope this makes sense...

I have a schedule with test environments in A3:A100 and timeline in B2:AZ2. Within B3:AZ100 there are text values in some of the cells. Please see example attached file (Schedule!).
I wish to be able to combine the rows for the same test environment into one row - keeping the text in the correct date order. Please see example attached file(Result!).

Thanks in advance.

 

[vletm]

Craig Monty
There are some cells which has 'not visible text values'
... gotta do it this way
Press the button in cell A1

 

[rahulshewale1]

Hii @Craig Monty ,


PFA Solution Using Power Query and Formula


Regard
Rahul shewale

 

[bosco_yip]

Formula solution without helper columns

In "Result" Sheet B3, copied across and down :

=IFERROR(IF(Schedule!B$2=B$2,IF($A3=INDEX(Schedule!$A:$A,AGGREGATE(15,6,ROW(Schedule!B$3:B$26)/(Schedule!B$3:B$26<>""),COUNTIF(B$1:B2,"?*"))),INDEX(Schedule!B:B,AGGREGATE(15,6,ROW(Schedule!B$3:B$26)/(Schedule!B$3:B$26<>""),COUNTIF(B$1:B2,"?*"))),""),""),"")

Regards
Bosco

 

[Craig Monty]

Thanks everyone for your super fast responses.

Have a great week.
Cheers