Stack multiple columns into 1

[tj_haines]

Hi - pretty new to this, and struggling to figure this one out. I have hundreds of columns I want to be stacked on top of each other, I've attached a sample of what I have and what I need.  Thanks in advance for any suggestions.

[binuacs · Accepted solution]

@tj_haines Transpose your data using the Transpose tool to get the result

[tj_haines]

Thanks, this should work.  First I have to get rid of hundreds of blank columns (there is a blank column in between each column of data). Is there an "easy" way to do that?

[LeTHo300]

Hi, tj_haines.

In addition to binuacs approach, are you able to follow this workflow? And was this helpful?