Completed

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

Skills: Excel, Google Sheets, JSON

See more: 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

About the Employer:
( 59 reviews ) Ramat-Gan, Israel

Project ID: #27482937

Awarded to:

uparejiya

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

$25 USD in 1 day
(0 Reviews)
0.0

16 freelancers are bidding on average $21 for this job

datakillers

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 More

$20 USD in 1 day
(323 Reviews)
7.6
Imranatmoon

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

$30 USD in 1 day
(50 Reviews)
4.9
crazynightwalker

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

$20 USD in 1 day
(25 Reviews)
4.7
Jatin77777

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 More

$25 USD in 1 day
(8 Reviews)
3.9
(4 Reviews)
3.5
ammar3215

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 More

$30 USD in 1 day
(3 Reviews)
3.1
psharma3368

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

$30 USD in 1 day
(2 Reviews)
2.4
apriyanka0222

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

$10 USD in 1 day
(1 Review)
2.2
imTuyen

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

$30 USD in 1 day
(0 Reviews)
0.0
pankajtiwaript08

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 days
(0 Reviews)
0.0
Jude03

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.

$10 USD in 1 day
(0 Reviews)
0.0
margieprinagel10

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 More

$10 USD in 5 days
(0 Reviews)
0.0
shakshisharma181

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 More

$10 USD in 1 day
(0 Reviews)
0.0
Raifree1

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 More

$20 USD in 2 days
(0 Reviews)
0.0
benson2augustine

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

$35 USD in 1 day
(0 Reviews)
0.0