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

[Frank DiPietro]

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.

[Jim Cone]

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
DiPietro@discussions.microsoft.com>
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.

[Frank DiPietro]

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
> DiPietro@discussions.microsoft.com>
> 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.
>