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
Bookmarks