SOLVED

Extract raw data and return in a list form

Brass Contributor

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

 

 

Convert Stock Data.xlsx

 

3 Replies
best response confirmed by packie (Brass Contributor)
Solution

@packie 

 

Please find attached document with proposed formulation.

 

Martin

@packie 

 

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)


Perfect!!
Amazing what excel can do.

Thankyou
1 best response

Accepted Solutions
best response confirmed by packie (Brass Contributor)
Solution

@packie 

 

Please find attached document with proposed formulation.

 

Martin

View solution in original post