Column to row

[Feras95p]

Dear all,

I have one row in excel which contains this data

Train

TS02

TS09

TS10

TS11

TS12

TS13

TS14

TS15

TS18

TS19

TS20

TS21

TS23

TS24

TS25

TS27

TS28

TS29

TS32

TS34

TS35

TS37

TS39

TS40

TS42

What I'm looking for is to have all this data in one cell to be like this

TS02-09-10-11-12-13-14-15-18-19-20-21-23-24-25-27-28-29-32-34-35-37-39-40-42

Any idea how can reach that?

[Felipe_Ribeir0 · Accepted solution]

Hi @Feras95p 

Here is one way of doing this:

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.

[binuacs · Accepted solution]

@Feras95p One way of doing this with the summarize tool