Forum Discussion
Needing Assistance with a fill formula
I have a report that is missing email data that I need to fill. Attached is the sample. I need the email to fill all the way down to the next email, then fill with the next email until the next and...
Thanks, I shortened it to 50 rows for this example Riny_van_Eekelen
MHall1966 Attaching the file with a PQ solution.
What I did is convert the sampla data to a structured Excel table (Ctrl-T). It's called "Table1". Not very original. Then I connected to that table with PQ, cleaned up a few things and filled down the e-mail addresses.
The end result is in the tab "Table1". What you need to do next is to copy your real data directly below the blue table and delete the first (example rows).
Then, on the Data ribbon select Refresh All and the Table1 tab shall be updated in a matter of seconds.