Remote Data Mining And Management Job In Data Science And Analytics

Excel Spread Sheet Design

Find more Data Mining And Management remote jobs posted recently Worldwide

I have a list of 1700+ Items in a spread sheet column A in order from top to bottom. The list includes blank cells in Column A.

I need a freelancer that can create a Microsoft Exel Spread sheet that can import my list and break it down into 3 columns per page across as many pages needed and keep the list in order.
And will also do the same into 2 columns per page and keep the list in order.

I need a new spreadsheet created that will do the following:

I want the new spreadsheet to be able to import my list in the exact order of the list.
I want cell 1 column A of my list to import to cell 1 of Column A of the new spread sheet. Then contents of cell 2 column A of my list populated to cell 2 Column A of the new list and so on down the list. When my list in gets down to the last printable cell of Column A page 1 of the new spread sheet, I want the next item in my list to populate into cell 1 of Column C page 1 of the new spread sheet and continue to the last printable row of the first page. When my list gets to the last printable row of Column C of page 1, I want the next item in the list to populate to cell 1 of column E of page 1 of the new spread sheet. After column E is populated to the last printable row, the next item on my list should be populated into cell 1 Column A of page 2 of the new spread sheet and the same process continue until the entire list is imported into the new spreadsheet at 3 columns per page keeping the list in order over as many pages as it takes to accept the list.

I also want a way for my list to be imported to a new spreadsheet with 2 columns per page using column A and column C of the newly created spread sheet.

I also want written instructions as to how to import my list into the new spreadsheet.

Font is Calibri Size 8. My Column A is 35 Calibri size 8 Capital Characters in Width




Column Size of the new spread sheet: Columns A, C, and E must fit 36 capital letters of Calibri size 8
Columns B, D, and F should be 3 capital letters wide of Calibri Size 8

The new spread sheet should be set up as default Calibri Size 8

When the page prints there should be no loss of items off the list nor loss of order of the list.
About the recuiter
Member since May 20, 2018
Patrick Brassar
from Margibi, Liberia

Skills & Expertise Required

Data Entry Microsoft Excel 

Candidate shortlisted and hiredHiring open till - Dec 24, 2019

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$52.12

Cost

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Similar Projects

Scrape website and get contact information of companies listed

Looking for someone to compile the data of companies from a webpage to a Google Sheet

Data to include more (an example will be provided to shortlisted candidates):
Company name
Full address
Name of CEO
LinkedIn URL of CEOread more

Scraping European video games publishers over the web

Looking for someone to scrap all the public email of European video games publishers over the web. Most important are the French, English and German one.

I need all those data store in an Excel files with this structure :
Company name -...read more

API Development (Connect Distributors website site product with my site)

Connecting my shopify store to my distributors. Products updates from the distributor should flow to my store. Which includes, New product, Price, Qty, Etc. Orders should be able to flow from my shopify store to my vendor of my choice. I work with...read more

Brother PT-P900 integration with excel with VBA P-bac.

Im looking to integrate buttons into the excel workbook that takes specific information and prints a sticker with corresponding info, we use the brother PT-P900 and we have printer templates for the stickers but Im lost when it comes to the VBA int...read more

Scrape Data Alibaba

I need to extract data from Alibaba. I need to get manufacturer, contact number, email, address, etc.. for multiple product classes.