I have a set of data 335 rows (each row = customer reference) which is cross-tabbed with up to 15 columns (each column = a lender) per row. Each cell contains a lender name which is written in a series of colour codes (background colour and text colour combinations) which represent one of 5 outcome codes for each cell. I need the data (TableData tab) reset into 3 columns: customer reference; lender name; outcome code (per Outcome example tab) using the KEY tab to determine 'outcome code '.
4 freelancers are bidding on average R143 for this job
Hello, I am John Ofagbe a professional web developer and software engineer. I have read through your project description and I can present the data as described.