item and time column lookup help

[BP9906]

I have several rows of a CSV lookup
Name,00:00,00:15,00:30
test1,A,A,A
test2,A,N,N

I want to matchup _time with the column name and give me that value for each of the rows.

_time=00:15 (ie bin span=15m _time)

results should be:

Name,result
test1,A
test2,N

How do I accomplish this since the columns have the values? I tried foreach and map, but have come up empty handed.

Thanks.

[jkat54]

You can open the csv copy everything and “paste special” then use the paste option that rotates the data 90 deg. Do that before indexing data...

Or you can use the transpose command to do the same at search time. Will have to dress it up a bit but it would look something like this after transpose

Col1, col2,
TestName, Time

Try this:

| transpose
| rename col2 as _time, col1 as Name