Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
is there any way to split multiple dates from each cell and produce corresponding records.
E.g in row given below I want one date in one single row. This is very critical for me. Please Help
49 | $10,634.96 | 2016/09/17: 0.5 hrs Total: 0.5 hrs | 2016/09/29: 1 hrs Total: 1 hrs | 2016/09/28: 2 hrs Total: 2 hrs | 2016/04/22: 0.5 hrs 2016/06/20: 0.5 hrs 2016/10/11: 0.5 hrs Total: 1.5 hrs |
Thanks
Sorry to ask you If possible, can you please share sample excel at least 10 columns. Because, i feel we can do this by using Cross table.
How to share file? I didn't find any option to attach file here.
I have to share as new thread. could u find that?
Got it, split Multiple dates
Let me play around, Here, I recommend you to delete new thread and use same here. I will attach for you
Can you check this?
what?..there is nothing to check.
Hahaha, you are not getting this ?
Makes sense. But I wonder how to get it for over 30 columns with no data anomaly in it.
Hi do u have any final solution now? today is my deadline