Hello Excel Experts,

Given the table below, is it possible to achieve the result as shown in the 3rd column.

I need it so that I can use the INDIRECT formula for it.

Row Number Column Text Desired Formula String
19:20,22:24,34 AA AA19:AA20,AA22:AA24,AA34
19,20,34 BC BC19,BC20,BC34
33,37:41 D D33,D37:D41