Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
The data below is an example of a much larger database. I am trying to find
a way to bring all lines of the description onto the same row as the date and amount. The problem I'm havinng is that the space between Date/Amt are of varying lengths. Thanks in advance for your help. Date Amt Desc 7/25 200,000 FUNDS TRANSFER (ADVICE 2008072500018226) SENT TO JPMORGAN CHASE / BNF=DREIER LLP OPERATING OBI= RFB=080725400069 07/25/08 09:53AM ET 7/28 3,000 AUTOMATED DEBIT NEOPOST POSTAGE CO. ID. 1942388882 080728 PPD MISC 46872331 7/29 5,000 TRNSFR 2000030910634 07/29 ONLINE TRNSFR CONFIRMATION # VY114369378 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I need to consolidate a list into rows | Excel Discussion (Misc queries) | |||
Consolidate data from worksheet (more then 65536 rows) | Excel Discussion (Misc queries) | |||
How to open/consolidate details for multiple rows in a PivotTable | Excel Discussion (Misc queries) | |||
Consolidate rows & amounts with the same heading | Excel Discussion (Misc queries) | |||
how to consolidate large worksheets w/ 800~1000 rows by category? | Excel Worksheet Functions |