Receipts & payments lines export copy to clipboard

last month I used this option to get all of the lines ( payment & receipt ) to make a report in Power BI,
image


the result is what I expected. Afterward I used power Query to clean the data.
When I want to repeat this for the month closing of may all of the data is paste in a single column?
what is going wrong? Isn’t there another export possible then copy to clipboard.
excel would be a great alternative. or beter a url link to get the data direct in power BI. Any help is greatly appreciated
Roger

1 Like

Hello @Roger_Van_Decraen,

This probably happened because you used Excel’s Text to Columns and never reset it back to delimited by tab.

1 Like