Forum Discussion
One to Many Record Dilemma
Greetings Gang, I have a situation where a client of mine is pulling in data into SharePoint from an InfoPath file that uses repeating tables - So when I connect the list records from the form...
Hi Matt, you could connect to your source files with Power Query and then use the 'Fill Down' functionality to fill in empty spaces below with the values of the non-empty rows above them.
Thank you, Yury, I'll give that a try and see how it works! I'll keep the board posted on the results!
Matt
Matt