Hi,
I would like to convert multiple columns into one column. I have 400 rows with 10 variables each. I used the OFFSET function but it return an error and I cannot understand where this error is.
Data start in Row A1 and go down to J400. I would like to transpose EACH row into a column and for them to be stacked one under the other so in the end I have a column with 400x10 data.
Would you be able to help me out spotting the error?
Please Login or Register to view this content.
Bookmarks