Completed

Transpose data in a Google spreadsheet

I will share with you a Google spreadsheet with two tabs: Input and Output. The project is to transpose data from the Input sheet into the Ouput sheet.

There are 150 rows in the Input which look like this:

5/9/18 Sell XLE and UUP

4/25/18 Buy GOOGL and EWJ

4/11/18 Sell SCO and TLT Buy XLE

4/4/18 Buy ASHR and EEM

3/28/18 Buy HYG and XLK

The Output sheet must be populated like this:

Symbol Direction Buy Date Sell Date

SLB buy 6/4/20 10/1/20

For example, for these input rows:

10/1/20 Sell SLB, KMI and PE, Buy ADBE, SE, SQ and W

6/4/20 Sell APT, Buy SLB, KMI, DAL, X

The Ouptut is (for SLB only; there should be additional output rows for the other symbols):

Symbol Direction Buy Date Sell Date

SLB buy 6/4/20 10/1/20

Additional detail:

* there are 150 rows in Input; each row may contain one or several symbols and actions (buy, sell)

* the Direction column in Ouput should be populated as follows: if Action is Buy, enter "buy". If action is Short, enter "sell"

Skills: Excel, Data Entry, Google Sheets

See more: php mysql data google spreadsheet, google spreadsheet data entry, google finance data excel spreadsheet, data google finance spreadsheet, excel spreadsheet import data google finance, import data wordpress google spreadsheet, android google data api spreadsheet, google docs data entry spreadsheet, google spreadsheet valid data script, psd form save data google doc spreadsheet, script sort data google spreadsheet, scrap data google spreadsheet, export mysql data google spreadsheet, import data google spreadsheet mysql, display data google spreadsheet google sites, fill data google spreadsheet, project for waboraro olefile i heard you were very good just fill data in spreadsheet for trials more jobs coming, external data google spreadsheet, how do i link data from one google spreadsheet to another?, google spreadsheet combine data from multiple tabs

About the Employer:
( 67 reviews ) Stamford, United States

Project ID: #30224116

Awarded to:

AccountantArman

"Sir, I am Excel Advance Level Expert. This is a basic work for me. i can complete this project with in Few hours with added quality. About me I am Chartered Accountant with more than 4 years of experience from worl More

$10 USD in 1 day
(54 Reviews)
4.8

20 freelancers are bidding on average $21 for this job

(250 Reviews)
6.9
(189 Reviews)
6.7
(189 Reviews)
6.6
sangwanpankajs

hello sir i have read your project description i can transpose this data in few hours only i am an expert in excel and have done many excel projects in past with excellent ratings so far open a chat session to dis More

$20 USD in 1 day
(95 Reviews)
5.6
UmarMahmood

Hello. I am an excel expert and can quickly complete thus task. You can pay me after the work is complete. Question: Is this a recurring task or one time task? If recurring, I can make a macro which can do it with one More

$20 USD in 7 days
(36 Reviews)
4.5
zaahidali61

Hi, I have read your project carefully and much interested to work on your project. I can transport data from input to out put as per your instruction. I can start immediately and will provide you a sample for your ap More

$30 USD in 2 days
(21 Reviews)
4.6
WelcomeClient

Hi, I am able to perform this task with 100% accuracy, let start with sample, i am ready now I have read your requirement and do understand your project. Having vast experience in this field I can assure you that i am More

$12 USD in 1 day
(36 Reviews)
4.5
Sunitav36

Hi Sir, i have Checked the Project: Transpose data in a Google spreadsheet I carefully read your project description & I can handle this in my best care and professional manner. Please message me to discuss the work. More

$25 USD in 1 day
(18 Reviews)
3.6
techno76

Dear Client, I read your job description.I have done projects in data entry and internet research. Work will be delivered with accuracy, I wish positive response from your side. Regards Dev.

$20 USD in 1 day
(12 Reviews)
3.3
MAhmedBilal

Hi, I have read your description carefully and I am interested in your project. I am professional data entry expert I have a good grip on google sheets. I can do your project on cheap rate but I can provide you the exc More

$10 USD in 1 day
(1 Review)
0.4
Boniface123

Hello dear, I am a specialit in data entry. I understand your project that transposing your data from the input to output. I am ready for this now, I am collaborative and serious; I look forwards to get hired and getti More

$20 USD in 1 day
(1 Review)
0.4
jpiyush385

Hi, I am Piyush Jain. I am trying new things in my life in the freelance business. I am very interested and want to develop my potential in the field of data entry administration. Thanku

$20 USD in 7 days
(0 Reviews)
0.0
marwanghazala

I understand you need to transpose data from the input tab to the output tab, I will do this for the 150 rows of data. I do not understand the way to transpose though, can you please send me a message via chat explaini More

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

Dear Sir   Thank you so much for sharing your Transpose data in a Google spreadsheet requirements here at freelancer and being a five-star rated freelancer, I love to work with you on this project and start immediately More

$15 USD in 7 days
(0 Reviews)
0.0
zohaibshah454

Hello, I read you project detail I will enter correctly the Symbol Direction Buy Date Sell Date which you want with 100% accuracy asap. Kindly share your document I will start. Thanks.

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

Hello There, I have read all your requirements, you need someone who transpose the input data into output data. It is pretty simple work, i have done this easily. Thanks

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

Hey there, I have read through the job details extremely carefully and I noticed that you require a person who can help you with lead generation. I believe that my experience and skills meet your project requirement. More

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

I am expert on data entry, excel, data analysis, google sheets, And I love my Work Not money. That's why my bit amount is low. You can give me the project for sure. I will make a very good project.

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

I am very excited to help you by completing your given task. and I am thankful for the opportunity provided .

$10 USD in 1 day
(0 Reviews)
0.0