| Date | TYPE | TIME |
| 01-01-2020 | A | 01:20 |
| 01-01-2020 | B | 20:30 |
| 02-01-2020 | A | 10:01 |
| 02-01-2020 | B | 10:20 |
| 03-01-2020 | A | 11:01 |
| 03-01-2020 | B | 11:10 |
| 04-01-2020 | A | 11:21 |
| 04-01-2020 | ||
| till month end | more TYPE (A,B)... | more times....(different times) |
How can i present table in
| TYPE | 01-01-2020 | 02-01-2020 | 03-01-2020 | 04-01-2020 | 05-01-2020 | 06-01-2020 | 07-01-2020 |
| A | 01:20 | 10:01 | |||||
| B | 20:30 | 10:20 |
Amit MohantyPosted Mar 29, 2023, 11:22 AM
Try this
akbar ansariPosted Mar 29, 2023, 11:35 AM
Thanks for your valuable reply. this is working.... but have one more issue with same table
I want to
VALUE A MIN([TIME]) and value B MAX([TIME])
is this possible??