Transpose (?)
 

In col A, the related data (from "Name" thru "Amount") exists in either
5 or 6 cells.

The cells containing the "Name", "Stock Number", "Street", "City" and
"Amount" ALWAYS exist but the cell containing the "Age" MAY not exist.

How can I "transpose" 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

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

Transpose (?)
 

Hi,

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

"GARY" wrote:

In col A, the related data (from "Name" thru "Amount") exists in either
5 or 6 cells.

The cells containing the "Name", "Stock Number", "Street", "City" and
"Amount" ALWAYS exist but the cell containing the "Age" MAY not exist.

How can I "transpose" 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

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

Transpose (?)
 

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: http://www.excelforum.com/member.php...o&userid=26500
View this thread: http://www.excelforum.com/showthread...hreadid=516090