Forum Discussion
Duplicating unique data in 12 rows of 3 columns
Riny_van_Eekelen Riny, thank you very much for your prompt reply.
The excel spreadsheet example you attached looks perfect, exactly what I am trying to accomplish.
But I think you are saying that you attached a "demonstration of a Power Query solution." I do not see this attachment.
And I am not sure what your lines describing the process mean. I do not know what "CONNECT" to the 12 x 3 range means. I do not know what Add and "INDEX" column means, etc.
Is there an attachment "demonstration of a Power Query solution" that I am not finding? Or is there a video or other tutorial on the Internet that you can point me to?
Thanks again for your help. I am excited to see your sample excel spreadsheet example.
Peace,
John
trinitystores Forgive me! I sometimes forget that PQ is perhaps the greatest secret of Excel. After 8-9 years it's still unknown to the majority of Excel users. The link below is a good starting point to start learning about PQ. It will enable you to find the steps that I described in my previous post.