Transpose (?)

[GARY]

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

 

[Guest]

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

 

[nsv]

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