C
Cydney
I have 9 sheets with over 9000 rows per sheet that I need to transpose this
example data:
ACCT # 132 TOTER QTY 1
NAME A COURTEOUS DAME TOTER #(S) 30524 NAME
SERVICE ADDRESS 4617 S HAPPY VALLEY RD BILLING ADDRESS
NAMPA ID 83686
PHONE 208-466-9547 DAY FRI PHONE
START DATE 03/06/07 RATE $14.80
OWNER(S) GWEN MOORE & JAMIE MALEC SERVICE
to this format:
--
Thank you, cs
~~~~~~~~~~~~~~~~~~~~~~~~
"What lies behind us and what lies before us are tiny matters compared to
what lies within us."
~ Ralph Waldo Emerson
example data:
ACCT # 132 TOTER QTY 1
NAME A COURTEOUS DAME TOTER #(S) 30524 NAME
SERVICE ADDRESS 4617 S HAPPY VALLEY RD BILLING ADDRESS
NAMPA ID 83686
PHONE 208-466-9547 DAY FRI PHONE
START DATE 03/06/07 RATE $14.80
OWNER(S) GWEN MOORE & JAMIE MALEC SERVICE
to this format:
--
Thank you, cs
~~~~~~~~~~~~~~~~~~~~~~~~
"What lies behind us and what lies before us are tiny matters compared to
what lies within us."
~ Ralph Waldo Emerson