I have an order of numbers in one column, I need to re-create this order except each number needs to be copied 13 times. How can I reference each order number 13x?
I have copied and pasted the first 3 order numbers to do this as shown in the image - any ideas on how I could automate this?
Example.jpg
Something like:
Please Login or Register to view this content.
(right click worksheet tab, click 'View Code', paste the code from above, press Alt-F4, press Alt-F8, click run, done)
Last edited by Olly; 02-19-2014 at 10:21 AM.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Wow!!! Thank you so much, It worked with no problems!
Of course it did
Thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks