Need Help Transposing First Row of Duplicate Names to a Column

I'm currently trying to transpose the first row based on the client name (there are many unique names) using the values under the column headers "Week 0" to "Week 13" and I'm having trouble due to the fact that I have 13 duplicates to help with indicating weeks 0-13 (ease of use in PowerBI). Is there a way to do this?

Example:
excel help.PNG

A picture of a worksheet is no use for working on, so it would help if you attached a sample Excel workbook. Put some realistic data in there (your picture seems to show only zero values), and indicate how you would like the data to be transformed, maybe with a Before and After sheet.

To attach a file, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Don't try to use the Paperclip icon, as it doesn't work on this forum.

Hope this helps.

Pete

Sorry about all that, essentially what I'm trying to do is transpose the first row values in 'Week 0' to 'Week 13' based on
'Client Name' into a new column next to the Week Number column so that it matches as the week column header
can be seen in the After sheet). I know there's a way to do it manually but I'm wanting to make it more efficient/automatic
since I have over 11,000 rows and 900 unique client names in the real dataset. Thanks!

You can put this formula in cell W2:

=INDEX(D2:Q2,MOD(ROWS($1:1)-1,14)+1)

then copy down as required.

Hope this helps.

Pete