Forum Discussion
Solved
consolidating excel sheets with different colonne lenght
hi, I wonder if some could help. I am trying to save time with the procedure with have now. Each year we use a different Excel sheets for the dairy entries (like SyndConta2019MSFT.xlsx and SyndCo...
- In the PQ editor you can filter away blanks.
Of course! Data, Get Data, From File, From Folder is your way to go!
Thank yoiu Jan,
I have tried it to import several files but it has a problem. The importation procedure imports also blank lines and the final excel sheet has 10 times the size of the data stored in indiviual excel sheets.
How could i solve this problem?
Thanks again, Juan
I have tried it to import several files but it has a problem. The importation procedure imports also blank lines and the final excel sheet has 10 times the size of the data stored in indiviual excel sheets.
How could i solve this problem?
Thanks again, Juan
- In the PQ editor you can filter away blanks.
- thanks!