Forum Discussion
packie
Jul 10, 2024Brass Contributor
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 CORP
And display in list form in a new sheet
- Martin_AngostoIron Contributor
- packieBrass Contributor
Perfect!!
Amazing what excel can do.
Thankyou
- Tejas_shahBrass Contributor
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)