How do I reverse a spreadsheet that is in the format of a subtota.
 

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.

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.

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.