software

In col A, the related data (from quot;Namequot; thru quot;Amountquot;) exists in either
5 or 6 cells.

The cells containing the quot;Namequot;, quot;Stock Numberquot;, quot;Streetquot;, quot;Cityquot; and
quot;Amountquot; ALWAYS exist but the cell containing the quot;Agequot; MAY not exist.

How can I quot;transposequot; the related data horizontally from Cols B thru G?
(Col A has 45,000 cells; too time-consuming to do COPY/PASTE
SPECIAL/TRANSPOSE).

For example, Col A contains the data; Cols B thru G is the result I'm
looking for:

A B C D E F G

1JONES JONESA-35 MAIN ST NEW YORK $45.00
2A-35
3MAIN ST
4NEW YORK
5$45.00
6SMITH SMITH24A-365 PINE AVE LOS ANGELES $123.08
724
8A-365
9PINE AVE
10LOS ANGELES
11$123.08
12ADAMS ADAMS 56 D-5989 FIRST ST SEATTLE $4,516.08
1356
14D-5989
15FIRST ST
16SEATTLE
17$4,516.08
18JOHNSON JOHNSON A-2 THIRD DR ATLANTA $1.58
19A-2
20THIRD DR
21ATLANTA
22$1.58
23PETERS PETERS D-247 OVERBY DR CHICAGO $3.02
24D-247
25OVERBY DR
26CHICAGO
27$673.02
28ALVERS ALVERS65Q-2456 2ND ST PHOENIX $6,304.59
2965
30Q-2456
312ND ST
32 PHOENIX
33$6,304.59Hi,

How can you transpose the data which contains 45,000 rows when there are
only 256 columns?

Sorry! Not only I, nobody can answer your question.

Regards,
NAVEEN

quot;GARYquot; wrote:

gt; In col A, the related data (from quot;Namequot; thru quot;Amountquot;) exists in either
gt; 5 or 6 cells.
gt;
gt; The cells containing the quot;Namequot;, quot;Stock Numberquot;, quot;Streetquot;, quot;Cityquot; and
gt; quot;Amountquot; ALWAYS exist but the cell containing the quot;Agequot; MAY not exist.
gt;
gt; How can I quot;transposequot; the related data horizontally from Cols B thru G?
gt; (Col A has 45,000 cells; too time-consuming to do COPY/PASTE
gt; SPECIAL/TRANSPOSE).
gt;
gt; For example, Col A contains the data; Cols B thru G is the result I'm
gt; looking for:
gt;
gt; A B C D E F G
gt;
gt; 1JONES JONESA-35 MAIN ST NEW YORK $45.00
gt; 2A-35
gt; 3MAIN ST
gt; 4NEW YORK
gt; 5$45.00
gt; 6SMITH SMITH24A-365 PINE AVE LOS ANGELES $123.08
gt; 724
gt; 8A-365
gt; 9PINE AVE
gt; 10LOS ANGELES
gt; 11$123.08
gt; 12ADAMS ADAMS 56 D-5989 FIRST ST SEATTLE $4,516.08
gt; 1356
gt; 14D-5989
gt; 15FIRST ST
gt; 16SEATTLE
gt; 17$4,516.08
gt; 18JOHNSON JOHNSON A-2 THIRD DR ATLANTA $1.58
gt; 19A-2
gt; 20THIRD DR
gt; 21ATLANTA
gt; 22$1.58
gt; 23PETERS PETERS D-247 OVERBY DR CHICAGO $3.02
gt; 24D-247
gt; 25OVERBY DR
gt; 26CHICAGO
gt; 27$673.02
gt; 28ALVERS ALVERS65Q-2456 2ND ST PHOENIX $6,304.59
gt; 2965
gt; 30Q-2456
gt; 312ND ST
gt; 32 PHOENIX
gt; 33$6,304.59
gt;
gt;


I think I understand your question fairly well, and this calls loudly
for a VBA macro solution. It can be done only if there is something to
mark where each block of data either begins or ends. Could this be the
$ sign in amount?

Place your question in the programming forum and good luck.NSV--
nsv
------------------------------------------------------------------------
nsv's Profile: www.excelforum.com/member.php...oamp;userid=26500
View this thread: www.excelforum.com/showthread...hreadid=516090