The project is straightforward. The attached file has graphic demonstration. You can also understand it by reading the following instruction.
First, you need to find the table with at the links I give. For example:
Table Link
PRINCIPAL AND SELLING STOCKHOLDERS [login to view URL]
SELLING STOCKHOLDERS [login to view URL]
SELLING STOCKHOLDERS [login to view URL]
PRINCIPAL AND SELLING STOCKHOLDERS [login to view URL]
Let’s say you click the link from first row, and you have found the PRINCIPAL AND SELLING STOCKHOLDERS table.
The table from the webpage needs to be converted to the table in Excel in the following format:
1. The subtitle for the name is taken out and put into a separate row.
2. The column name has been merged. The name of the second column is “Number of Shares Beneficially Owned Prior to the Offering Number”, and the third is “Number of Shares Beneficially Owned Prior to the Offering %”
3. All the percentage numbers are having no %. So the numbers are 100 times the original one. This number is important. Don’t get them wrong.
I have about 250 tables to collect, and I need them to be done in a day or two. Please send me your results for the four links I put above. I will not award the project without seeing your small sample output.