Help me with a simple XL formula, in order to generate a JSON file

I have an XL sheet in the following structure:

A: Title | B: Description | C: Value

Oranges | Fresh | 30 days

Oranges | Bad | 7 days

Oranges | Decent | 10 days

Lemons | Fresh | 8 days

Lemons | Bad | 10 days

Lemons | Decent | 30 days

I need to return all of the values (array) from B, that match a string that will be looked in A.

Expected outcome:

Oranges | Fresh, Bad, Decent

Lemons | Fresh, Bad, Decent

Beceriler: Excel, Google Sheets, JSON

Daha fazlasını gör: export excel to json, nested json to excel, excel convert json to columns, how to open json file in excel 2016, excel formula parse json, excel json parser, json to excel, import json into excel 2013, oracle generate xml file, generate ics file, generate xml file excel script, articulate quizmaker generate exe file, generate xls file php, generate csv file rss feed, can articulate generate csv file, generate dat file excel, sharepoint generate unique file name list item, jquery remote json file, php generate ics file, simple asp program form data csv file

İşveren Hakkında:
( 59 değerlendirme ) Ramat-Gan, Israel

Proje NO: #27482937



Hi there, I have good experience on excel formulas, message me and lets finish this quickly. Thanks

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(0 Değerlendirme)

Bu iş için 16 freelancer ortalamada $21 teklif veriyor


Hi,I am an Excel Expert with Professional experience working with Excel. I have more than 10 year experince with excel. Complete a lot of jobs on Freelancer with highly satisfaction of client. I believe I can do a grea Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(323 Değerlendirme)

Hi There, Super Easy I already have the vba code ready. Available and ready to share. Regards Imran

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(50 Değerlendirme)

Hi, this is very easy to do, I can help you achieve the desired output easily. Do you need this in Excel or Google Spreadsheets? I am ready

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(25 Değerlendirme)

Hello, I have gone through with contents and understand the requirements. This is pretty straightforward task and I am interested to do this work and break your huddle. Please allow me to do this job. I am available to Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(8 Değerlendirme)
(4 Değerlendirme)

I am a pro in excel with 7 years of experience , I completely understood the task and will match up as desired i.e I will return all of the values (array) from B, that match a string that will be looked in A easily , p Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)

hello sir I can create php script to read excel file and convert into json format according to your requirements after sort a and b please text me so we can discuss more about task. thanks

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)

Hi.. I can do your work accurately as per your requirements. Please text me so that we can discuss about this further.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)

Hello Sir. I can do this project. I am a professional Linux and developer in PHP, Wordpress, Laravel, Magento, Joomla, Prestashop, OpenCart, Yii, NodeJS, Angular, Vue.js, HTML5, CSS3 and jQuery. I can do this project. Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

Hi! I can help you finishing your project in 1 day. I am good in Excel, PDF, Word and Copy Typing so we can make an arrangement. Looking forward to hear from you.

$10 USD in 7 gün içinde
(0 Değerlendirme)

Hi, I am Allan. I have a wide knowledge of Microsoft Excel I gain from years of working with it. I can this job for you. Kindly send me the file and I revert it back ASAP.. Thank you.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

Hi, I am hardworking and discipline. Please give me an opportunity to provide excellent work for you. Based on my skills and experience. I am confident that I can do a great job for you. Here my attached resume, sampl Daha Fazla

$10 USD in 5 gün içinde
(0 Değerlendirme)

i can do this, i will use a python code for this, we will load the excel to csv to python code then we can run the following code - title_list = [ ] -> contains all the title des_list = [ ] -> contains all the descrip Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)

Hello there I am Abhishek(Data Entry Expert) with expeirience of more than 5 years. I am working for multiple client internationally and made them happy by providing them more than their expectations. -I assure you Daha Fazla

$20 USD in 2 gün içinde
(0 Değerlendirme)

hi friend, i got ur requirement its like u want {'orange':['good','bad']} like this right? i can do it , im a software developer by profession , i can help u , text me if u r interested we can fix it together

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)