Assist with moving data in a different structure way...

[Kouliscon]

hello all,

currently my data is structured at the table below:

	1/3/2022	1/5/2022	1/10/2022
Item 1		626
Item 2		1,575
Item 3	255		255

and i would like to have it as the table below:

Item 1	626	1/5/2022
Item 2	1,575	1/5/2022
Item 3	255	1/3/2022
Item 3	255	1/10/2022

any formula as if i can move that to the way i want it?

thank you

[#2 · Accepted solution]

@Kouliscon 

Try the Unpivot Columns feature of the Query Editor (Data tab of the ribbon > Get Data > From Other Sources > From Table/Range).