Make Table a Crosstab VBA

[ms372]

I am trying to write a macro so that I can upload my excel data to a program.

I need to convert from this format:
Capture0.PNG


to this format:
Capture.PNG

Can anyone help?

I have been able to merge the patient name and MRN fields, but can not reformat to get the data elements in rows rather than columns. Manually moving or using the Paste-transpose function wont work as I plan to use this macro for large files w/ thousands of data rows that need to rapidly converted to the new format.

Thank you

[MarvinP]

Hi ms and welcome to the forum,

I just got done writing the code but can't post it until you EDIT your first post and change the thread title to something like "Make Table a Crosstab VBA". We require threads to be titled something non generic (like "help me please!") so we can find them again in a search.

You change the thread title and I'll give you two different methods for doing your job.

[YasserKhalil]

The title of the thread has been changed Mr. Marvin
I'm a follower of this thread

[MarvinP]

Hi Yasser,

I had forgotten about this thread. Find attached the macro and workbook to solve this problem. Thanks for asking again as this put it in view.

[ms372]

This is very helpful. Thanks so much!