Rearrange data

Hi everyone,

As shown in "Before" tab in excel, my current data arrangement is horizontal, and my objective is to organize the data as shown in the "After" tab - where the data arrangement is vertical.

Anyone that know how this can be accomplished?

My data set is quite large, so doing this manually would take ages.

Thank you.

Perhaps with a macro?

To test run macro "ArrData" and check result in "After" sheet.

Alf

The macro worked brilliantly - thank you so much for your help.

You are welcome.

Thanks for feedback and rep

Alf

Ps As this seems to solve you problem, dont forget to mark thread "Solved" as per forum rules.

To mark your thread solved do the following:
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved