How to group list of names and values from different dates

[Anonymous]

Hey all , 

i would like to group data list with a lot of chemistry names , dates and quantity in to centered data to all name it self , i mean turn this table :

into this format:

Chimestry	Inventory  23/12/22	Quantity 23/12/22	Inventory 24/12/22	Quantity 24/12/22
Beca	68	20	68	36
BPS	0	3	0	2

for each chimestry for 7 dates (the data contains more than 7 days) , I feel really lost hope for somebody help

[Anonymous · Accepted solution]

Hi @Anonymous 

You can use matrix visual

e.g

Put the Chemistry to the "Rows" then put the DMY to the "Columns"  , then put the Inventory and N rows to the value:

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Shamkosar]

Hi, Try using a matrix table instead