add one dimension to array

yes sir haha

Please Login or Register  to view this content.

Converts 1D array to 1 Based 2D array.

hi
sorry for that but i still dont understand this method(only when paste vertical to horizontal and vice versa)
can u show me the full code to convert one dimension array to 2D?
column A is identifier(one number) and the the B column(same row) is data breaks by commas(1,4,3,2,4,0,0,0,3,2...)
i just want for each of those rows to make column A as the first dimension(the number of elements is the rows number) and the second dimension is the data in column B

Ahhh, you want it as

Please Login or Register  to view this content.

But why do you need it so?

Transpose will give you

Please Login or Register  to view this content.

So this is not what you want.

I don't understand why you need it an array...

I would do like

Please Login or Register  to view this content.

i heard that arrays works much faster than others methods
actually it's a game results
each row is a player
the "1,3,2,4,0,3,2,..." (column B) is the answers of the player for each question
finally i want to know the percentages for each answer for each question
after i got an array(x,y) ; x-index of player ; y-all the answers
i'll be able to continue with the calculations(and there are a lot of games)

It depends how you use it.
In your case, it is not much difference.

the issue is that i need that array for calculation
simple example: only one game, only 4 players,only 4 questions,only 4 answers for each question:
after i get the array i want to do:

Please Login or Register  to view this content.

If you upload a workbook with data and the result taht you want, it may help understanding what you are trying to do.
However, reading your code is not understandable.

If you know about array, you should have loaded the data with loop or even manually, because it is 0 based.
So how would I know what you want to do?

ok...i think i got it
the issue was because i have to declare number of elements to the array...something with "Redim"

Please Login or Register  to view this content.

its not clean but it work now (based on my worksheet data)

Thanks u for the effort