List items several times with multiple results in pivot table

I am not sure how to explain this to make it not seem so complicated, because I think it should be quite simple, I am just not getting the right setup in my pivot table.

I have column A with 16,000 part numbers.
The rest of the columns list videos associated with each part number.
F, H, J, L, N all have the number of the video that is tied to the part number.

I attached an image with the spreadsheet setup.
In the end, I want the pivot table to list the each part number with each video, but as a line item for each instance.

AAA-WWGP 12
AAA-WWGP 2
AAA-WWGP 1
AAA-WWGP 1
AAA-WWGP 2
ABC-00001 22
ABC-00001 16
ABC-00002 14
ABC-00002 158
ABC-00002 22

I appreciate anyone's help in getting this to work as it will save me a ton of time. Thanks so much!Capture.PNG

It sounds like you actually want to unpivot your data, which you can do using a consolidation range pivot table: https://contexturesblog.com/archives...ot-excel-data/

is one example.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data. Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Also - which Excel version do you use?

You can easily use Power Query to unpivot your date.

Format your source data as a table, then use query:

Please Login or Register  to view this content.

This will tel you how to switch on Power Query: https://www.excelcampus.com/install-power-query/

See link in my signature for how to use Power Query code.

It's well worth it.

Thanks. I will give that a try.