Find more Data Mining And Management Remote Jobs posted recently Worldwide

Required Data Entry,Microsoft Excel freelancer for Excel Spread Sheet Design job

Posted at - Jan 30, 2023


I have a list of 1700 Items in spreadsheet 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 Excel Spreadsheet that can import my list and break it down into 3 columns per page across as many pages as 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 spreadsheet. The 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 gets down to the last printable cell of Column A page 1 of the new spreadsheet, I want the next item in my list to populate into cell 1 of Column C page 1 of the new spreadsheet, and continue to the last printable row of the first page. When my list gets to the last printable row of Column C on page 1, I want the next item in the list to populate cell 1 of column E on page 1 of the new spreadsheet. 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 spreadsheet and the same process continues 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 spreadsheet.

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 spreadsheet: 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 spreadsheet 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 the order of the list.

About the recuiterMember since Nov 11, 2022 Bali Mechanic Media Website Dept.
from Maryland, United States

Skills & Expertise Required

Data Entry Microsoft Excel 

Candidate shortlisted and hired
Hiring open till - Mar 3, 2023

Work from Anywhere
40 hrs / week
Fixed Type
Remote Job
$72.39
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


Apply on more work from home jobs posted in Data Mining And Management category.