Forum Discussion
Solved
Extract raw data and return in a list form
Hi, Here is sample of raw data in the attached file: "2": { "cik_str": 1045810, "ticker": "NVDA", "title": "NVIDIA CORP" In the above example what I want to do is extract NVDA NVIDIA C...
Please check the attached file. I have highlighted cell for the desired result.
=WRAPROWS(TEXTBEFORE(TEXTAFTER(TEXTAFTER(TRIM(FILTER('Raw data'!$D$5:$D$48,ISNUMBER(SEARCH("Ti*",'Raw data'!D5:D48)))),": "),""""),""""),2)