Help with reorganizing raw data on a different sheet

[RockFish]

Hello,

Note: I attached my file because my explanation of my problem may be confusing.

I have raw data which is organized with the Item # and Process listed vertically and the Date listed horizontally. I would like to show this data with the Item # listed vertically and the Date and Process listed horizontally. I would like the date to be repeated with each step in the process to each item. Currently, the date is only listed once because the Item # and Process are listed vertically. Each unique date will go from being listed once per column to being repeated 5 times (once for each of the 5 steps). I will manually build this part of the working sheet. I need a function that changes the numbers from running vertically to horizontally. I manually typed in some numbers in my file which may give you a better idea of my intention. Basically, I think I am trying to transpose the numbers, but I don't think the transpose function will work with how I need my data organized. Please see my attached sample file.

Thank you!

[JBeaucaire]

In B3, then copied down and across:

=INDEX('Raw Data'!$C$2:$E$21, MATCH($A3&B$2, INDEX('Raw Data'!$A$2:$A$21&'Raw Data'!$B$2:$B$21, 0), 0), MATCH(B$1, 'Raw Data'!$C$1:$E$1, 0))

[MarvinP]

Hi Rockfish and welcome to the forum,

See the attached where I started with you raw data and used "Get & Transform" to UnPivot the date columns. Then using the result on sheet1 did a Pivot Table to get what I think you want as an answer.

UnPivot took about 5 mouse clicks and the Pivot took about 5 more.

1. Click anywhere in your raw data table.
2. Click Data Tab - From Table/Range then OK (make sure "my data has headers" is checked)
3. Select first two columns in the Query Editor then right click on a column head and select "UnPivot Other Columns"
4. Click column1 header and change data type to date.
5. Close & Load.

This is how I made sheet1.

Do a pivot table with sheet1 to get what I think you want, attached.

PQ UnPivot then Pivot as OP wants.xlsx

[RockFish]

Thank you JBeaucaire! The function you provided worked great! My actual data covers 12+ months, but I was able to simply modify your function to cover additional months.

[RockFish]

Thank you MarvinP! Your recommendation looks like it should work. I will definitely spend some time learning how to use "Get & Transform to UnPivot columns. This is a great tool!

[JBeaucaire]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.