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


hello all,


currently my data is structured at the table below:

Item 1 626 
Item 2 1,575 
Item 3255 255


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


Item 16261/5/2022
Item 21,5751/5/2022
Item 32551/3/2022
Item 32551/10/2022


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


thank you

1 Reply
best response confirmed by Kouliscon (Visitor)


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