Transposing a Long String

G

Guest

I use some long strings like these:

A0;A4;A5;A6;A8;A9;AC;AS;AI;AK;AN;AO;AP;AQ;B5;B9;BA;BB;BC;BD;BE;BH;C2;C3;C4;CA;CB;CC;CG;CH;CI;CK;D0;D2;D3;D5;D6;E1;E3;E4E9;F3;F6;F7;F8;G0;G2;G4;G7;G8;G9;GC;GE;H2;H3;H6;I0;DA;B7;J0;J4;K0;K2;K3;L0;L2;L3;L5;L7;L9;M1;M3;M5;M7;M8;M9;MA;MB;MF;MH;N0;N4;N5;N6;N7;N8;AG;P0;P1;P6P8;Q0;Q3;R1;R4;S0;S1;S2;S3;S5;S6;S7;SA;SB;SC;SD;SE;T1;T2;T3;T8;U0;U3;U4;V0;V1;V4;W2;W3;W4;X0;X1;X2;Y0;KO;LO;MO;NO;OO;PO;QO;RO;SO;TO;UO;VO;XO;FP;GP;HPIP;JP;KP;LP;MP;NP;OP;PP;QP;RP;SP;TP;UP;VP;WP;YP;FQ;GQ;HQ;IQ;KQ;LQ

The string is in 1 cell.

Is there a way to take the string and transpose it into separate rows. For
example:

A0
A4
A5
..
..
..
LQ

Thank you in advance.
 
F

Frank Kabel

Hi
one way without VBA or formulas:
1. Use 'Data - Text to columns' and the semicolon as delimter to split the
string in separate columns
2. Copy these cells
3. Paste them with 'Edit - Paste Special - Transpose'
 
J

Jason Morin

If your string were in A1 of Sheet1, place this in A1 of
a new worksheet and copy down:

=MID(Sheet1!$A$1,ROW()*3-2,2)

HTH
Jason
Atlanta, GA
 
Top