Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Unpivot idea for complex and irregular data structure

Hi, 

 

anyone has idea to take this uneasy data for query?

need to filter date and details per columns. 

the most difficult part is we don't know how much columns will be added every month. 

e.g. 2023P02 is two but it can be 3 or more next mont depends on new PO. 

 

 

1 Reply

  • Hi,

    Share the download link of the MS Excel file and in another tab of that file, show the desired structure/result.