Forum Discussion
Lookupvalue will not return time value
Hi Kristen,
You can use Query editor as well to solve this type of problem.
Just few mouse clicks and you are done. Follow the screenshots for exact solution.
Merge Table 2 and Table 1 as shown in the ScreenshotExpand the new column and select Event Type & Time of Event CheckboxesChange the data Type of the last column to Time and Rename both the columnsTime of the Event Column with new Data TypePivot the Column. Select the options shown in the screenshotAll done. TA....DA........
Hi Kristen,
You can use Query editor as well to solve this type of problem.
Just few mouse clicks and you are done. Follow the screenshots for exact solution.
Merge Table 2 and Table 1 as shown in the ScreenshotExpand the new column and select Event Type & Time of Event CheckboxesChange the data Type of the last column to Time and Rename both the columnsTime of the Event Column with new Data TypePivot the Column. Select the options shown in the screenshotAll done. TA....DA........
Thank you so much for this! I had tried merging queries but pivoting was completely new to me. Grateful to have learned something new.
Thank you!