VBA from (multi) column to rows

I often see files built up in columns (week from A to Z)

If you want to use a pivot table it's easier to re-arange the data from columns into rows.

Who can help me with a macro which will do that for me.

In the attached file, also is the desired result.

For the example please post the result in another sheet.

Do you have questions or comments, just ask or comment.

Hi.

Check this macro. I have a sheet "output" where you can verify the final data.

VBA Qeuestion columns to rows Oeldere.xlsm

Thanks jraj1106 and nilem for the code.

I'm gonna work with it at the end of the day.

I will report the result at the end of the day.

@jraj1106

Please Login or Register  to view this content.

The code is working (and i think i understand most of the code). Thank you for that.

I changed / added the blue text.

I have a question on the red text.
It seems to be the same line twice (or do I read it wrong).

Why is that?

@Nilem

Your code is working perfectly. Thanks for that.

But i'm unable to read (and understand) it well enough, to use it for future use.

May as well post this.

Please Login or Register  to view this content.

@Norie,

Couldn't make it that way, but I think i'm able to read (and understand) the code.

Thanks for posting your code.