Ungrouping date ranges

%3CLINGO-SUB%20id%3D%22lingo-sub-719460%22%20slang%3D%22en-US%22%3EUngrouping%20date%20ranges%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-719460%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20have%20a%20table%20from%20an%20existing%20database%20that%20is%20showing%20price%20between%202%20dates%2C%26nbsp%3B%20i%20want%20to%20transform%20these%20into%20a%20daily%20price%20table.%26nbsp%3B%3C%2FP%3E%3CP%3Eplease%20tell%20me%20im%20being%20stupid%20and%20that%20there%20is%20a%20quick%20way%20to%20do%20this.%3C%2FP%3E%3CP%3EData%20is%20going%20back%20to%202016.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

i have a table from an existing database that is showing price between 2 dates,  i want to transform these into a daily price table. 

please tell me im being stupid and that there is a quick way to do this.

Data is going back to 2016.

 

Many thanks