Hi,
I have issue. When I converted bank statement pdf file to excel. Excel made 3 rows in purpose section, but amount is only in one row. How can I merge these 3 rows automatically when merged row is in the same line as amount?
Hi,
I have issue. When I converted bank statement pdf file to excel. Excel made 3 rows in purpose section, but amount is only in one row. How can I merge these 3 rows automatically when merged row is in the same line as amount?
Welcome to the forum
MS-Off Ver is in your profile so that you can tell us which version of Office you are using.
Different versions have different capabilities.
Replies on threads are tailored to match the version of Office that you are using.
Entering "is nice" in the box does not help us help you.
EDIT
Thank you for amending your profile
Last edited by kev_; 02-20-2018 at 01:44 PM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
It would be easier if we can see the problem.
I appreciate that some of the information is confidential, but you can amend the text in the Excel file to make it anonymous.
Just make sure that the problem to be fixed is obvious.
Please attach your workbook with 2 sheets
- sheet1 as converted from PDF
- sheet2 how you want it to look
To attach file
click GoAdvanced \ look below and click ManageAttachments \ follow screen instructions
Thank you
Last edited by kev_; 02-20-2018 at 02:06 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks