| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
Thanks Jim. That worked great!
"Jim Cone" wrote: Frank, Check this out... http://j-walk.com/ss/excel/usertips/tip040.htm "Duplicate repeated entries in a list " Regards, Jim Cone San Francisco, USA ----- Original Message ----- From: "Frank DiPietro" <Frank Newsgroups: microsoft.public.excel.misc Sent: Tuesday, January 18, 2005 6:25 AM Subject: How do I reverse a spreadsheet that is in the format of a subtotal. I have a spreadsheet that details transactions by vendor but there is one line for the vendor and the detail transactions fall below the vendor line. The detail transactions do not show the vendor name. I need to have the vendor name on each line of the detail so I can sort and analyze the data. This is actually a report exported from QuickBooks. The only option I see is to copy the vendor name to each detail line and then remove the original vendor line. This is a lot of manual labor for a pretty large spreadsheet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change Excel format to pdf format? | Excel Discussion (Misc queries) | |||
| Importing Data From Another Spreadsheet | Excel Discussion (Misc queries) | |||
| How do I convert exel spreadsheet to works spreadsheet? | Excel Discussion (Misc queries) | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
| How do I cancel sending a spreadsheet by email? | Excel Discussion (Misc queries) | |||
Threaded Mode
