We have multiple excel files with data and we need a script or software to use to parse the data into a clean csv table, access, or other format.
1. some fields have multiple entries that need to duplicated by the script
2. other fields have image icons that need to spell out as text
attached is a sample excel file with 2 tabs
Source: this will be the way the data will be input into the software
Output: this is the preferred way we want the data to be processed
explain what your solution would be and what experience you have doing this work
26 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
Hi i have doubt : [url removed, login to view] you want to remove duplicate from column D and column D ? [url removed, login to view] icon for example in 1st row that should be spell as "S" as text ? [url removed, login to view] else processing you need ? Please discuss , i can Lisää
I have expertise in Excel, VBA.. Through VBA I can copy any no. of excel cells from here and there.. I can provide you a full-fledged solution.. Thank you..