SOLVED

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

Visitor

hello all,

 

currently my data is structured at the table below:

 1/3/20221/5/20221/10/2022
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)
Solution

@Kouliscon 

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