I scraped a pdf from page 1 to nth page. How can i merge the the data in excel file and keep the data aligned?

Help Studio
, ,
1

A-B are invoice date and number. The only problem I failed to add their headers using Add Colum.
C-G is the first page I scraped and H-L is the second page I scraped. I want to scrap the second page and merge it under C-G.

sheet1.1
sheet1.11000×477 18.1 KB
sheet1.2
sheet1.2995×492 17.5 KB

Thanks in advance

2

This is what I want to fix

sheet1.2
sheet1.2995×492 22.1 KB

3

@samuel.chaane - Not sure why the 2nd page values writing in Column H-L.

Try copy range and move the values to desired columns.

image
image1862×503 21.3 KB

4

I m scrapping multiple docs, so if I am going to scrape 3 pdf’s it means its gonna happen 3 times. So copying and moving will be hard coding I think. I need an alternative to make it not happen