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 |