Convert Columns to rows with DATA

hi all this is my first topic in here, i have a problem in copying many columns to to rows that originally contains data, this is gonna be really complicated so here is wt i want, let's assume i have this table

A B C D
1 9 24 25 26
2 11 24 434 888

what i want is to concatenate the data in columns B,C,D etc. to the data in column A each in a separate row so i get the following table:

A
1 924
2 925
3 926
4 1124
5 11434
6 11888

so in other words i want to concatenate the data in A1 to the data in b1,c1,d1.....etc and then put the output in one column

thanks in advance

Hello raed_237,

Welcome to the forum!

with your data in columns A, B, C & D, try this in F1

=INDIRECT("A"&ROUNDUP((ROW())/3,0)) auto-fill down the column

Then in G1

=INDIRECT("B"&ROUNDUP((ROW())/3,0))

Then in G2

=INDIRECT("C"&ROUNDUP((ROW())/3,0))

Then in G3

=INDIRECT("D"&ROUNDUP((ROW())/3,0))

Then select cells G1:G3 and auto-fill down

Does that work for you?

Have a look at the attached worksheet for an alternative using a compound formula in column H.

Name your data range 'data', then copy the formula in H1 to your H1, then copy down.

If you use a different column you will get an incorrect result

Regards
Mike

PS sorry for the strange workbook title - should be 5 cols to one...