earthworm
Well-known Member
- Joined
- May 19, 2009
- Messages
- 759
- Office Version
- 2019
- 2016
- Platform
- Windows
I have Data in 2 sheets . Row count 1 million + . First I need to append the data through power Query and remove duplicates. Then I want to export the data back into excel table. Since when data is merged in appended table in power Query and size has increased , I can't export back to excel table. Please help because there is a row limitation on single sheet. Is there any option that can automatic export data into respective sheet when data row size exceeds single sheet ?