@AamerMalik
Do you have some sample data? Would need it in excel/text/csv since will be doing this in PQ.
But high level:
- Group by stock
- Order each sub-table from date old to new
- Add an index column to each sub table
- Expand the final table out
@AamerMalik
Do you have some sample data? Would need it in excel/text/csv since will be doing this in PQ.
But high level: