Hello.
Let's say I have a worksheet with a list of names, like so:
Aragorn the Ranger
Bilbo the Hobbit
Celeborn the Elf
Let's say that, on another worksheet, I want that list of names with every name in triplicate, like so:
Aragorn the Ranger
Aragorn the Ranger
Aragorn the Ranger
Bilbo the Hobbit
Bilbo the Hobbit
Bilbo the Hobbit
Celeborn the Elf
Celeborn the Elf
Celeborn the Elf
Is there any way of doing this?
Try:Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thank you! Is it possible to make it not sort things alphabetically?
You're welcome. Thanks for the rep.
The solution relied on the Sort to group the repeated values. I'm not that familiar with functions in Google sheets. I guess you'd need to repeat each cell and then stack them.
No matter, the alphabetical sorting you provided me with works just fine, so it's all good. Again, thank you TMS!
You're welcome.
Yes it is, remove SORT( and the last ) from the formula.Is it possible to make it not sort things alphabetically?
If you want the source list to be in any order, and the output must be triplicate rows of each name, then you can use this:
Please Login or Register to view this content.
As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.
And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks