force to single column

E

EngelseBoer

Can someone here please tell me how i can force the following.....

2 rows of 3 cells each.....
row 1 = A B C
row 2 = 3 1 2 (but these numbers are variable)

these 2 rows represent (in this case) 3 x A, 1 x B and 2 x C
i want the data above to be forced into a single column in this manner

A
A
A
B
C
C

with no blank cells inbetween

if for example the numbers were A=1 B=2 C=3
then the rusult must be

A
B
B
C
C
C

with no blank cells inbetween

I hope someone can help - my EXCEL knowlege is somewhat - very - limited

Regards
Malcolm
 
I

Infinitogool

Hi EngelseBoer

Try this formula in cell A3
=MID(REPT($A$1,$A$2)&REPT($B$1,$B$2)&REPT($C$1,$C$2),ROW()-2,1)
Copy down as far as needed

Regards,
Pedro J.
 
E

EngelseBoer

THANX
That is EXACTLY what i need

Thanks ever so much Pedro
Regards
Malcolm (EngelseBoer)
 
E

EngelseBoer

UMM ONE PROBLEM...
it forces me to use rows 1 and 2 with results from row 3 down...

i need it much lower on the sheet

what need to change please?

Regards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenating adjacent cells ignoring blanks and adding a delimite 3
Excel Concatenate with line breaks but ignore blank cells 3
counting groups of blank cells 3
tiny discrepancies in fixed-point numbers 3
Concantenating non adjacent cells 6
Concatenating non adjacent cells 2
How to group all data from 1 column into several columns 2
How to group all data from 1 column into several columns (Redo) 2

Top