Hi, I have pdf wanted to upload in power bi, in that pdf I have 4 columns (city, unit name, contact, address) and 8 tables with the same column name. I wanted to consolidate all tables into 1 table.
| City | unit name | contact | address | 
| bhopal | mp nagar | 8770761966 | plot no 45 hoshangabad road bhopa | 
| indore | 56 dukan | 3543657334 | dukan no. 56 chappan road indore | 
Table 2
| City | unit name | contact | address | 
| Prayagraj | sangam | 4534563345 | kuch bhi addrss sample | 
| Rewa | maple | 8775938587 | lknav fni ample sample | 
Result
| City | unit name | contact | address | 
| bhopal | mp nagar | 8770761966 | plot no 45 hoshangabad road bhopa | 
| indore | 56 dukan | 3543657334 | dukan no. 56 chappan road indore 
 | 
| Prayagraj | sangam | 4534563345 | kuch bhi addrss sample | 
| Rewa | maple | 8775938587 | lknav fni ample sample |