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

On Sun, 7 Sep 2008 08:28:01 -0700, dr
wrote:

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


Assuming your data is in columns A to F and on rows 1 to 75.
Try the following formula in cell G1:

=IF(MOD(ROW(),7)=0,"",INDEX($A$1:$F$75,1+INT(ROW()/7),MOD(ROW()-1,7)+1))

Copy down to row 525 (75*7)

Then copy column G and Paste Special (Values) it to column H
Finally delete columns A to G.

Hope this helps / Lars-Åke

Should be fairly quick. Takes col i:n and puts in col H. Just change to suit
making sure a clear column to the left.

Sub transposeblocks()
mc = 9 'column I
j = 1
lr = Cells(Rows.Count, mc).End(xlUp).Row
For i = 1 To lr
Cells(i, mc).Resize(, 6).Copy
Cells(j, mc - 1).PasteSpecial Paste:=xlPasteAll, Transpose:=True
j = j + 7
Next i
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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

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

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

If printing labels in Word from data in XL ... still a bad idea!

BUT ... each to his own.<g
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Don Guillett" wrote in message
...

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

"Ours not to reason why, ours to but do or die" <G

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ragdyer" wrote in message
...
If printing labels in Word from data in XL ... still a bad idea!

BUT ... each to his own.<g
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Don Guillett" wrote in message
...

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

YOU can die ... I DYE!<bg
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Don Guillett" wrote in message
...
"Ours not to reason why, ours to but do or die" <G

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ragdyer" wrote in message
...
If printing labels in Word from data in XL ... still a bad idea!

BUT ... each to his own.<g
--
Regards,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"Don Guillett" wrote in message
...

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