table transpose help

[josh_m]

i have a report that is getting to wide in excel to be manageable. it is a "punch-list" of sorts that lists known issues with various stores. it lists 10 issues per location, and each issue has 4 columns associated with it, so I am now 40+ columns wide.
if anyone could help with a macro that could rearrange this report, it would save me a lot of copy/paste time.

additional notes: when the report is exported to excel, it is the only active sheet in the workbook. i guess the code would need to insert sheet 2 and paste the data there

thanks a lot for any help you can give

It basically looks like this:

table.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}
.tableizer-table th {background-color: #104E8B; color: #FFF; font-weight: bold;}


storeCityStatetypedateissue #1quantity #1resolution #1ordered #1issue #2quantity #2resolution #2ordered #2REPEATING ALL THE WAY TO #10issue #10quantity #10resolution #10ordered #10aknoxvilletnlarge1/1/12             bhoustontxsmall1/2/12             cmiamiflmedium1/3/12             dromegasmall1/4/12

i would like to get it to look like this to be readable on the screen and where it can print nicely

table.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;}
.tableizer-table th {background-color: #104E8B; color: #FFF; font-weight: bold;}


storeCityStatetypedateissuequantityresolutionorderedaknoxvilletnlarge1/1/12    aknoxvilletnlarge1/1/12    aknoxvilletnlarge1/1/12    aknoxvilletnlarge1/1/12    aknoxvilletnlarge1/1/12    aknoxvilletnlarge1/1/12    aknoxvilletnlarge1/1/12    aknoxvilletnlarge1/1/12    aknoxvilletnlarge1/1/12    aknoxvilletnlarge1/1/12    bhoustontxsmall1/2/12    bhoustontxsmall1/2/12    bhoustontxsmall1/2/12    bhoustontxsmall1/2/12    bhoustontxsmall1/2/12    bhoustontxsmall1/2/12    bhoustontxsmall1/2/12    bhoustontxsmall1/2/12    bhoustontxsmall1/2/12    bhoustontxsmall1/2/12

 

[josh_m]

grrr...

 

[josh_m]

to clarify, this is what it looks like...

store

City

State

type

date

issue #1

quantity #1

resolution #1

ordered #1

issue #2

quantity #2

resolution #2

ordered #2

REPEATING ALL THE WAY TO #10

issue #10

quantity #10

resolution #10

ordered #10

a

knoxville

tn

large

1/1/12

b

houston

tx

small

1/2/12

c

miami

fl

medium

1/3/12

d

rome

ga

small

1/4/12

<tbody>
</tbody>

this is how i would like it to look...

store	City	State	type	date	issue	quantity	resolution	ordered
a	knoxville	tn	large	1/1/12
a	knoxville	tn	large	1/1/12
a	knoxville	tn	large	1/1/12
a	knoxville	tn	large	1/1/12
a	knoxville	tn	large	1/1/12
a	knoxville	tn	large	1/1/12
a	knoxville	tn	large	1/1/12
a	knoxville	tn	large	1/1/12
a	knoxville	tn	large	1/1/12
a	knoxville	tn	large	1/1/12
b	houston	tx	small	1/2/12
b	houston	tx	small	1/2/12
b	houston	tx	small	1/2/12
b	houston	tx	small	1/2/12
b	houston	tx	small	1/2/12
b	houston	tx	small	1/2/12
b	houston	tx	small	1/2/12
b	houston	tx	small	1/2/12
b	houston	tx	small	1/2/12
b	houston	tx	small	1/2/12

<tbody>
</tbody>