Forum Discussion
How to Convert New Sales Territory/Rep Data Table with Single Date "Event" Rows
Thank you, ZhangKun, SundarRaj and ronrsnfld, for your responses.
Hi zwyatt,
We would like to check if the solution provided by ZhangKun, SundarRaj, ronrsnfld has resolved your issue. If you have found an alternative approach, we encourage you to share it with the community to assist others facing similar challenges.
If you found the response helpful, please mark it as the accepted solution. This recognition benefits other members seeking solutions to similar queries.Thank you.
Hi zwyatt, another solution I could work out using Power Query. Thanks. I'll attach the file link. Have a look if that is what you intend to do with your query.
https://docs.google.com/spreadsheets/d/1a3q1IxlqHrM_Jgajq6B0zOkyni2vLFV9/edit?usp=sharing&ouid=104752674875039603034&rtpof=true&sd=true