Do some Excel Work
$10-30 USD
Paid on delivery
I have an excel file which has columns A through DM, and Rows 1 to 3479.
Some of the cells have 3 Rows of data. I need the rows converted to columns. Just the ones that have data.
Example Cell BY has two rows with data, 16, & 17 that say
Activity Start Date:(7/21/2014 12:00:00 AM)
Activity End Date:(12/6/2014 12:00:00 AM)
I need BY,17 Activity End Date moved to a new Column BZ
Column CY has three rows of data 16,17,18 that contain
Activity Cost:: 15,000.00
Bursary Amount:: 11,800.00
Fees Charged:: 3,200.00
I need this data moved to CZ16, DA16, DB16
There are approximately 10 columns formatted this way, and many rows.
I need someone to create an excel Macro that can take the additional rows, and move the data into columns.
I will need instruction on how to implement the Macro.
Project ID: #5549426
About the project
Awarded to:
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
5 freelancers are bidding on average $28 for this job
Hi, I will be happy to help you with this macro . -----------------------------------------------------------------------------------
hi, excel expert here. i have lot of experience in excel works.. i can do this job quickly.. thanks, Tristan