Transform data in matrix

[Anonymous]

Dear all,

I have a table of data in excel as below, could you please advise how can I transform data as expected for analysis.

Thanks for your support!

Look forward to hearing from you soon.

Original data: group of 3 by product, owner and size. Some cases owner are 2 people.

Jan

Feb

Mar

Factory

W1

W2

W3

W4

W5

W6

W7

W8

W9

W10

W11

W12

W13

South Factory

Table

Table

Chair

Table

Jack&Joe

Joe

Jack

Jessica&Jack

Small

Small

Large

Large

Chair

Table

Chair

Table

Joe

Jessica&Carol

Jessica

Marry

Large

Large

Large

Small

North Factory

Chair

Chair

Carol

Joe&Marry

Small

Large

I have data about size and list of owner:

Owner	Size
Jack	Small
Joe	Large
Carol
Jessica
Marry
Jack

Please advise how can I get data as below:

Factory	Month	Week	Product	Owner	Size
South Factory	Jan	W2	Table	Jack&Joe	Small
South Factory	Jan	W3	Chair	Joe	Large
North Factory	Jan	W4	Chair	Carol	Small
South Factory	Feb	W5	Table	Jack	Small
South Factory	Feb	W6	Table	Jessica&Carol	Large
South Factory		W8	Chair	Jack	Large

[ziying35]

Hi, @Anonymous 

Will there be more than two product information from the same factory in the same week?

[Fowmy]

@Anonymous 

Hi, Please check the attached file, 

You can download the file: HERE

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[Anonymous]

Hi @Fowmy ,

The file used in report from your C:/ so I can not see the data (Screenshot 1), if I pass the link of my data, there is error below (screenshot 2). Please help to advise.

[Fowmy]

@Anonymous 

The source data : https://1drv.ms/x/s!AmoScH5srsIYgYNuS6LdlDetCbna6Q?e=c4UEDY

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[Fowmy]

@Anonymous 

Can you share some sample data in CSV or Excel format?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?

_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[Anonymous]

Hi @Fowmy ,

Please find the link of excel file as below. Appreciate your support!

https://drive.google.com/file/d/1pL-ZGGqKKPFUc0-g6lT-jaiMfyHdRLzd/view?usp=sharing