Macro to Repeat Copy/Transpose in a List

[fearonc]

Perhaps someone can help. I have scoured the internet for similar situations using macros for repeat copy/transpose functions but have not been successful in achieving a successful result. I have toiled with this for hours. There are 1594 entries in the original list. I have attached a sample file with a list with just 5 names. I would like to develop a macro that turns the ‘Master’ tab to the “Desired’ tab. Thanks for any help you can provide!

[JohnTopley]

Please Login or Register  to view this content.

OR formula:

In A1

=IFERROR(INDEX(Master!A$1:A$100,(ROWS($1:1)-1)*3+1),"")

copy across tp C1

in D1

=IFERROR(INDEX(Master!C$1:C$100,(ROWS($1:1)-1)*3+2),"")

in E1

=IFERROR(INDEX(Master!C$1:C$100,(ROWS($1:1)-1)*3+3),"")

Copy all down