Transpose Text to Columns

[Cydney]

I have 9 sheets with over 9000 rows per sheet filled with data that needs to
be moved into Access. So I need to transpose the multiple sets of 7 rows into
organized columns in another sheet appending each sheet into one.

Original Data looks like this:
(these are in 2 column sets with title in first, data in second -- columns
A-G)
(a) (b) (c) (d) (e) (f)
Acct: 12345 Qty: 1 (blank)
NAME: Joe Brown Qty No: 30524a NAME: Joe Brown
Address: 123 South 9th Qty No: 30524b Billing Addr: address1
Address2: Apt B Qty No: 30524c Billing Addr2:
address2
Phone: 123-555-1122 Day: Friday Phone: 123-555-1122
Start Date: 05-05-05 Rate: $5.00 (rate is alone in column
E) Check Info#1: (text)
Owner: Joe Brown Service: (test) Check Info#2: (text)
(blank row here)

I need to transpose everything so that it lines up in columns in a new sheet.

Can you help?
--
Thank you, cs
~~~~~~~~~~~~~~~~~~~~~~~~
"What lies behind us and what lies before us are tiny matters compared to
what lies within us."
~ Ralph Waldo Emerson

 

[Don Guillett]

Kind of hard to visualize the way it comes out on screen. If desired, send
your wb to my address below with a full explanation and before/after
examples.

 

[Cydney]

OK. I've sent you my example file. (Sorry about the previous mess.)
--
Thank you, cs
~~~~~~~~~~~~~~~~~~~~~~~~
"What lies behind us and what lies before us are tiny matters compared to
what lies within us."
~ Ralph Waldo Emerson