So I want to copy my bank statement into excel, but when I do, rather than separating each line into a row of separate cells, it separate it into a column of separate cells. and it does this for each row in the same column.
So:
A1 is in the right spot
A2 should be B1
A3 should be C1
A4 should be A2
A5 should be B2
A6 should be C2
etc....
anyway I can sort this out at the touch of a button? (or a few buttons)
you will probably need a VBA solution. Suggest you post a sample spreadsheet of what your import looks like with dummy information and then what you would like the sheet to look like afterwards.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
If your bank is like mine, you should be able to download the data in Excel format. The prompt could be hidden amongst a bunch of other banking services.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
After the download, you may need to use Text2Columns to split it apart
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks