Unless for a label or ??

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ragdyer" wrote in message
...
FWIW, IMHO,

You're not making a wise decision in revising your data to this type of
configuration!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"dr" wrote in message
...
I have a spreadsheet with data arranged like:
Case ID+ Priority* Type* Item* Group+ Create Date

It is 75 Rows long.

I need to convert the data to look like the following:

Case ID+
Priority*
Type*
Item*
Group+
Create Date

Case ID+
Priority*
Type*
Item*
Group+
Create Date

Case ID+
Priority*
Type*
Item*
Group+
Create Date