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

Compétences : Excel, Google Sheets, JSON

en voir plus : 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

Concernant l'employeur :
( 59 commentaires ) Ramat-Gan, Israel

Nº du projet : #27482937

Décerné à:


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

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(0 Commentaires)

16 freelances font une offre moyenne de 21 $ pour ce travail


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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(323 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(50 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(25 Commentaires)

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(8 Commentaires)
(4 Commentaires)

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(3 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(2 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(1 Évaluation)

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. Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)

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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)

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 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(0 Commentaires)