Unable to Reformat a List of Data into Desired Format

[jeff2302680]

After trying for a few days to figure this out and searching online, I decided to reach out for some help on trying to get a list of data (my "source" data worksheet) to output in a different format on another worksheet within the same workbook.

I included an attachment showing exactly what I am trying to accomplish.

In the attachment, I show just 3 weeks of data, although in actuality my actual list will include many years of data and will be updated continually.

Any ideas for the solution are greatly appreciated.

[FDibbins]

Please provide an excel workbook, not a zip file.

If your file is so large that you needed to zip it to upload it here, then it is too large for what we need.

We only need a SMALL clean file with just enough data to show examples of what you are working with (maybe 20-30 rows), as well as showing what you expect.

[jeff2302680]

OK I edited the attachment in the original post per your request.

Thanks!

[JeteMc]

This proposal converts the range A4:G22 into a table and adds a column for week number.
The column for week number is populated using: =COUNTIFS(B$5:B5,B5)
The output is in rows 12:16
1. Column J contains the week numbers
2. Row 11 contains day of week (not merged and centered) using: =IF(L12<>"",L12,K11)
Note that row 11 could be hidden, for aesthetic purposes, by choosing white font.
3. Rows 12:13 are manually pasted from rows 4:5
4. K14:AO16 are populated using: =INDEX(Table1[[UPR]:[Cndle]],AGGREGATE(15,6,(ROW(Table1[DOW])-ROW(Table1[#Headers]))/(Table1[DOW]=L$11)/(Table1[Wk]=$J14),1),MATCH(L$13,Table1[[#Headers],[UPR]:[Cndle]],0))
Let us know if you have any questions.

[jeff2302680]

Just - WOW. I am just completely blown away by how well and how fast you solved this.

For most things, I can search them out and/or figure out on my own- but I realized after awhile that this task was FAR BEYOND my capability. Thank you JeteMc for not only solving this problem, but providing the actual solution as well. I don't think I could have done this just going on some basic instructions. I hope that it did not consume too much of your time.

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.