This should be a real quick project for someone that knows macro or scripts with excel.
I need to list data that is USUALLY on THREE LINES to be put into one line.
You can see in the original file, there is a column for VOTER NUMBER, it and will usually have 3 lines (sometimes 1, or 2) with the same voter number.
It shows their response to THREE Questions. I need to combine their Human response in the proper column as shown in the finished File. I have used color coding to help show you how the data should be moved.
I need their responses put in order as shown in the Finished File.
I cut/copied/paste special (transpose) to move the names into the proper spot, and deleted the blank rows. This is time consuming and there should be a way to build an excel macro/script to do it automatically.
It is your choice. It must match up exactly with original file (if 3 responses on Voter Number, 3 names, if 2 responses, then 2 names, etc.)
Need this quickly
I could not post the Original File here, but you can find it at this link:
https://www.scriptlance.com/f/?128699488657175082
The example of what is needed can be found at this link:
https://www.scriptlance.com/f/?128699492958089988
You just need to write a macro that will give me what I want. I need the macro AND the finished file with the conversion.
Budget $20
