Transform data in matrix

Question

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.&nbsp;Original data: group of 3 by product, owner and size. Some cases owner are 2 people.&nbsp;Jan&nbsp;&nbsp;&nbsp;Feb&nbsp;&nbsp;&nbsp;Mar&nbsp;&nbsp;&nbsp;&nbsp;FactoryW1W2W3W4W5W6W7W8W9W10W11W12W13South Factory&nbsp;Table&nbsp;&nbsp;Table&nbsp;&nbsp;Chair&nbsp;&nbsp;Table&nbsp;&nbsp;&nbsp;&nbsp;Jack&amp;Joe&nbsp;&nbsp;Joe&nbsp;&nbsp;Jack&nbsp;&nbsp;Jessica&amp;Jack&nbsp;&nbsp;&nbsp;Small&nbsp;&nbsp;Small&nbsp;&nbsp;Large&nbsp;&nbsp;Large&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Chair&nbsp;&nbsp;Table&nbsp;&nbsp;Chair&nbsp;&nbsp;Table&nbsp;&nbsp;&nbsp;&nbsp;Joe&nbsp;&nbsp;Jessica&amp;Carol&nbsp;Jessica&nbsp;&nbsp;Marry&nbsp;&nbsp;&nbsp;&nbsp;Large&nbsp;&nbsp;Large&nbsp;&nbsp;Large&nbsp;&nbsp;Small&nbsp;North Factory&nbsp;&nbsp;&nbsp;Chair&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Chair&nbsp;&nbsp;&nbsp;&nbsp;Carol&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Joe&amp;Marry&nbsp;&nbsp;&nbsp;&nbsp;Small&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;LargeI have data about size and list of owner:OwnerSizeJackSmallJoeLargeCarol&nbsp;Jessica&nbsp;Marry&nbsp;Jack&nbsp;&nbsp;Please advise how can I get data as below:FactoryMonthWeekProductOwnerSizeSouth FactoryJanW2TableJack&amp;JoeSmallSouth FactoryJanW3ChairJoeLargeNorth FactoryJanW4ChairCarolSmallSouth FactoryFebW5TableJackSmallSouth FactoryFebW6TableJessica&amp;CarolLargeSouth Factory&nbsp;W8ChairJackLarge&nbsp;

fowmy · Answer

Anonymous&nbsp;Hi, Please check the attached file,&nbsp;You can download the file:&nbsp;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&nbsp;

fowmy · Answer

&nbsp;Anonymous&nbsp;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 · Answer

Hi&nbsp;Fowmy&nbsp;,&nbsp;Please find the link of excel file as below. Appreciate your support!&nbsp;https://drive.google.com/file/d/1pL-ZGGqKKPFUc0-g6lT-jaiMfyHdRLzd/view?usp=sharing&nbsp;

anonymous · Answer

Hi&nbsp;Fowmy&nbsp;,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.&nbsp;&nbsp;

fowmy · Answer

Anonymous&nbsp;The source data :&nbsp;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

Forum Discussion

Transform data in matrix

6 Replies

Related content

Data transform using power query

Eventhouse data transformation

Data Transformations

Table Transformation

Real time data transformation options

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