Hi i have below data & i want to display like below. I want to concat Item for a particular day.
Id Code Date Value 1 1 01/10/2022 5000 2 1 02/10/2022 1000 3 2 04/10/2022 10000 Code ItemCode Date Qty 1 I1 01/10/2022 4 1 I2 01/10/2022 2 1 I1 02/10/2022 4 2 I3 04/10/2022 20 Code ItemCode Date 1 I1 01/10/2022 1 Output like below 1 01/10/2022 I1-3,I2-2 5000 02/10/2022 I1-4 1000 2 04/10/2022 I3-20 10000
Thanks