Add info to Datascratping-obtained data

Hi.
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;

Product-A customer Price
HHHHH 20000
CCCCC 4500
FFFFFF 7500
DDDDD 5000
GGGGG 15000
YYYYY 4500
IIIIIII 7500
UUUUU 20000
JJJJJ 4500
Product-B customer Price
CCCCC 4500
DDDDD 5000
FFFFFF 7500
GGGGG 15000
HHHHH 20000
IIIIIII 7500
JJJJJ 4500
UUUUU 20000
YYYYY 4500

What I would like to do is combine both data and also add product name on column C such as following;

customer Price Product
HHHHH 20000 A
CCCCC 4500 A
FFFFFF 7500 A
DDDDD 5000 A
GGGGG 15000 A
YYYYY 4500 A
IIIIIII 7500 A
UUUUU 20000 A
JJJJJ 4500 A
CCCCC 4500 B
DDDDD 5000 B
FFFFFF 7500 B
GGGGG 15000 B
HHHHH 20000 B
IIIIIII 7500 B
JJJJJ 4500 B
UUUUU 20000 B
YYYYY 4500 B
※ 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!

Best,
Carmen