Excel Spread Sheet Design

Budget

$75.00FIXED

Client

Patrick Brassard Liberia

Status

OpenFeb 27, 2019
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.

Skills & Expertise Required

Data Entry Microsoft Excel 

Offer to work on this project closes in 125 days!

Submit A Proposal

Share this project with your friends



Freelancers You May Hire


Here are our top professional picks for you to hire



Similar Projects

Database Cleanup

I need to clean up my database.

I have approximately 3000 contacts that need to be verified and about 2000 companies.

For contacts, I need to have them cross referenced with Linked...read more

Hourly, $14.00

Create pivot table in Excel 2019

I need to create pivot table for the Excel to aggregate transactions by date for stocks bought and sold as follows:

Account Action Shares
Account F1 Bought 9000
Acco...read more

Hourly, $5.00

Need to extract,operate and store l...

I need to extract live market data from cryptocurrency websites(api tickers or whatever means necessary) and perform certain basic arithmetic operations like percentage gain on the data and store the...read more

Fixed, $70.00

exel take date in pdf and return th...

I need to take the serial number product into exel and check the serial inside the catalog of product that is in PDF
and found the number of the, FIG and Item
and take them and copy into...read more

Hourly, $10.00