join?

[Hi2023]

Hi, 

I am stuck on how to do this step

I have 5 columns loc # 20, loc #30, loc #50, loc # 70, loc# 40 -how do I merge these as one? I can do a join for one but not for all?

thanks

[binuacs]

@Hi2023 All your 5 fields in one file? Can you elaborate on your requirement? 

[Hi2023]

yes there are all on same file just diff columns

[binuacs]

@Hi2023 Can you elaborate on the part of your requirement "how do I merge these as one?"

[Hi2023]

sorry I want all the loc# to be as one column

[binuacs · Accepted solution]

@Hi2023 I would use the transpose tool in that case.