I would like to have your advice regarding adding information to data table which is obtained from “Datascratping” action.
I need to obtain several data from a website such as following.
My current program search for, for example, purchase information of “Product A” and “Product B”. Both data will be as following;
What I would like to do is combine both data and also add product name on column C such as following;
※ I need column C because in the end I need to make a pivot data.
My current program just over-writes when downloading the data table of Product B.
So my questions are below 2 points.
1)How should I set up to add column C information? I need to know how to specify the start and end of the table.
2)How could I set up to write the product B information comes under that of product A without over-writing?
Please let me know if I do not make myself understood.
Thank you in advance for your help and advise!