Filter data from semi-structured data

[aeolus187]

Hi Alteryx engineers,

I have data read like this, each column is a set of data which might come with several rows,  I have filter like OM02 and i want to locate the data that i need is from  second column, then i will go for 13L in second column and get the number 25264 which is what i want. how I can implement this? 

TIME:  02:26	TIME:  02:26
DATA: 01 OF 08	DATA: 01 OF 08
ERROR CODE:     -                      TANDEM DT: 20220221	ERROR CODE:     -                      TANDEM DT: 20220221
16L                              balahbalah	16L                              balahbalah
20L                       ZZ REFERENCE	20L                       XX REFERENCE
20C       OM01	20C       OM02
13L     25266	13L     25264

[binuacs]

@aeolus187 Not sure you are looking for something below

[aeolus187]

@binuacs 

The data set might not only two columns and i don't think we can use filter to set [F2] as filter option, cause OM02 might exists in any column of those dataset and filter can't help me located the column that contains OM02,  

[binuacs · Accepted solution]

@aeolus187 in that case use a transpose tool

[aeolus187]

@binuacs 

THIS ONE IS REALLY GOOD THANKS A LOT!