View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bernieb[_2_] bernieb[_2_] is offline
external usenet poster
 
Posts: 1
Default crosstable to column

hello everybody
I have a little problem, I have a table in my excel worksheet,
like this for example:
1 2 3 4
5 6 7 8
where the number of rows and columns can vary.
I would like to transform this table in one column, like this:
1
5
2
6
3
7
4
8
Can anybody help me? Do I need a macro for this?
Thanks a lot
bernie