Hi All

my problem is that i have a huge number of rows and columns, what i want is to concatenate the data in all the columns to the data in the first one, but separately, this is really complicated, so let us assume that i have the following table

-----A-----B-----C-----D-----E

1 ---98---13----17----19----44

2 ---94---18----20----23

3 ---19---22----245---45----62

so after concatenating the value in A to all the values in the other columns and put the result in a new column we get the following output

-----A

1---- 9813

2---- 9817

3---- 9819

4---- 9844

5---- 9418

6---- 9420

7---- 9423

8---- 1922

9---- 19245

10--- 1945

11--- 1962

also we need to take in consideration the empty cells as they must be skipped during the process, also please find attached my Excel sheet that needs the modification

my problem is that i have a huge number of rows and columns, what i want is to concatenate the data in all the columns to the data in the first one, but separately, this is really complicated, so let us assume that i have the following table

-----A-----B-----C-----D-----E

1 ---98---13----17----19----44

2 ---94---18----20----23

3 ---19---22----245---45----62

so after concatenating the value in A to all the values in the other columns and put the result in a new column we get the following output

-----A

1---- 9813

2---- 9817

3---- 9819

4---- 9844

5---- 9418

6---- 9420

7---- 9423

8---- 1922

9---- 19245

10--- 1945

11--- 1962

also we need to take in consideration the empty cells as they must be skipped during the process, also please find attached my Excel sheet that needs the modification

## Comment