Forum Discussion
Automatic duplicate cells by X
I've attached a basic example of the spreadsheet I'm trying to build (as the real version is sensitive material) This is an order form in which one person will paste in the addresses as copied fr...
Hi,
If you are familiar with the Power Query (aka Get & Transform Data), you can use it to get the output that you want.
Please check out the attached file to see the solution.
Hope that helps