Merge Columns to Rows

Any takers?

maybe so

Please Login or Register  to view this content.

Originally Posted by nilem

maybe so

Please Login or Register  to view this content.

Hi! Thank you very much for this. It seems to work perfectly well with the sample data I attached! :-)

However, when I try to use it for real data (i.e. where there about around 200 rows for each student, and about 10 or 11 subjects [approx. 60/66 columns] for each of those students), the code breaks at this point:

y(k, n + 4) = x(i, j + n)

The error I get is 'subscript out of range'.

Is there any way of tweaking this code so that it takes into account these extra rows/columns?

Help please... still trying to figure this out. :-(

Please attach the sample (Excel book with a desired result) you are working on with the code and will adjust it for you.
Nilem did not see your sample when he wrote the code.

Originally Posted by AB33

Please attach the sample (Excel book with a desired result) you are working on with the code and will adjust it for you.
Nilem did not see your sample when he wrote the code.

Hi. How can I attached a sample sheet? I can't see the option anywhere....

Ah, I found the 'attach file' button, but when I click it, nothing happens. Maybe our IT department at work have blocked pop-ups.

In any case, the sample spreadsheet can be downloaded from this link: http://www.filedropper.com/sampledata-mergecolstorows

The code works on the sample, but not on real data. Click Go advance, then at the bottom, you will see "Manage attachment" Upload Files from your Computer will take to your folder.

Originally Posted by AB33

The code works on the sample, but not on real data. Click Go advance, then at the bottom, you will see "Manage attachment" Upload Files from your Computer will take to your folder.

I've attached the sample spreadsheet now...

Thanks in advance!

Ah dah!

Nilem code works on the sample attached.
Then I asked you to attach a sample book which mimics your actual result, but you attached the same sample book.
The code is sensitive to boundry, so we know to know your data layout.
Please attach a sample which resembles your actual data. You can remove confidential info, we just interested on the layout and format of your actual data

Originally Posted by AB33

Ah dah!

Nilem code works on the sample attached.
Then I asked you to attach a sample book which mimics your actual result, but you attached the same sample book.
The code is sensitive to boundry, so we know to know your data layout.
Please attach a sample which resembles your actual data. You can remove confidential info, we just interested on the layout and format of your actual data

Ah, right. I'm at home now, so will post a full sample tomorrow when I'm back at work.