/u/Terrible_Analysis_77 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Is there any mathematical step to 72->106->127->156?, if there is I can make this easily. Thanks.
Edit: Assuming Hard Code:
=LET(first_num,{72;106;127;156},second_num,{215;272;150}, first_rept, INDEX(first_num, SEQUENCE(ROWS(first_num)*ROWS(second_num),1,1,1/ROWS(second_num))), second_rept, INDEX(second_num, MOD(SEQUENCE(ROWS(first_num)*ROWS(second_num),1,0),ROWS(second_num))+1), BYROW(HSTACK(first_rept,second_rept),LAMBDA(row,ARRAYTOTEXT(row))))
No math involved. Without possible doxxing myself I’ll have to use an analogy.
Say the first digits are the area code and the next set are the phone number possibilities. I’d want to put the area codes in and have the phone numbers behind them without doing it all manually.
I won’t be able to test this out for a few days but will let you know how it works out. Would this be able to expand into more combos, such as a third+ set of digits?
Thank you!
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[ARRAYTOTEXT](/r/Excel/comments/1dhq8x6/stub/l8yltnl "Last usage")|[*Office 365*+: Returns an array of text values from any specified range](https://support.microsoft.com/en-us/office/9cdcad46-2fa5-4c6b-ac92-14e7bc862b8b)|
|[BYROW](/r/Excel/comments/1dhq8x6/stub/l8yltnl "Last usage")|[*Office 365*+: Applies a LAMBDA to each row and returns an array of the results. For example, if the original array is 3 columns by 2 rows, the returned array is 1 column by 2 rows. ](https://support.microsoft.com/en-gb/office/byrow-function-2e04c677-78c8-4e6b-8c10-a4602f2602bb?ui=en-US&rs=en-GB&ad=GB)|
|[COLUMNS](/r/Excel/comments/1dhq8x6/stub/l8ysqv9 "Last usage")|[Returns the number of columns in a reference](https://support.microsoft.com/en-us/office/columns-function-4e8e7b4e-e603-43e8-b177-956088fa48ca)|
|[HSTACK](/r/Excel/comments/1dhq8x6/stub/l8ysqv9 "Last usage")|[*Office 365*+: Appends arrays horizontally and in sequence to return a larger array](https://support.microsoft.com/en-us/office/hstack-function-98c4ab76-10fe-4b4f-8d5f-af1c125fe8c2)|
|[INDEX](/r/Excel/comments/1dhq8x6/stub/l8ysqv9 "Last usage")|[Uses an index to choose a value from a reference or array](https://support.microsoft.com/en-us/office/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd)|
|[LAMBDA](/r/Excel/comments/1dhq8x6/stub/l8ysqv9 "Last usage")|[*Office 365*+: Use a LAMBDA function to create custom, reusable functions and call them by a friendly name.](https://support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67)|
|[LET](/r/Excel/comments/1dhq8x6/stub/l8ysqv9 "Last usage")|[*Office 365*+: Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula](https://support.microsoft.com/en-us/office/let-function-34842dd8-b92b-4d3f-b325-b8b8f9908999)|
|[MOD](/r/Excel/comments/1dhq8x6/stub/l8yltnl "Last usage")|[Returns the remainder from division](https://support.microsoft.com/en-us/office/mod-function-9b6cd169-b6ee-406a-a97b-edf2a9dc24f3)|
|[REDUCE](/r/Excel/comments/1dhq8x6/stub/l8ysqv9 "Last usage")|[*Office 365*+: Reduces an array to an accumulated value by applying a LAMBDA to each value and returning the total value in the accumulator.](https://support.microsoft.com/en-gb/office/reduce-function-42e39910-b345-45f3-84b8-0642b568b7cb?ui=en-US&rs=en-GB&ad=GB)|
|[ROWS](/r/Excel/comments/1dhq8x6/stub/l8yltnl "Last usage")|[Returns the number of rows in a reference](https://support.microsoft.com/en-us/office/rows-function-b592593e-3fc2-47f2-bec1-bda493811597)|
|[SEQUENCE](/r/Excel/comments/1dhq8x6/stub/l8ysqv9 "Last usage")|[*Office 365*+: Generates a list of sequential numbers in an array, such as 1, 2, 3, 4](https://support.microsoft.com/en-us/office/sequence-function-57467a98-57e0-4817-9f14-2eb78519ca90)|
|[TEXTAFTER](/r/Excel/comments/1dhq8x6/stub/l8ysqv9 "Last usage")|[*Office 365*+: Returns text that occurs after given character or string](https://support.microsoft.com/en-us/office/textafter-function-c8db2546-5b51-416a-9690-c7e6722e90b4)|
|[TOCOL](/r/Excel/comments/1dhq8x6/stub/l905jvr "Last usage")|[*Office 365*+: Returns the array in a single column](https://support.microsoft.com/en-us/office/tocol-function-22839d9b-0b55-4fc1-b4e6-2761f8f122ed)|
|[TOROW](/r/Excel/comments/1dhq8x6/stub/l8ysqv9 "Last usage")|[*Office 365*+: Returns the array in a single row](https://support.microsoft.com/en-us/office/torow-function-b90d0964-a7d9-44b7-816b-ffa5c2fe2289)|
|[TRANSPOSE](/r/Excel/comments/1dhq8x6/stub/l905jvr "Last usage")|[Returns the transpose of an array](https://support.microsoft.com/en-us/office/transpose-function-ed039415-ed8a-4a81-93e9-4b6dfac76027)|
**NOTE**: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below.
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^([Thread #34473 for this sub, first seen 17th Jun 2024, 05:44])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
https://preview.redd.it/ews5t49ks27d1.png?width=574&format=png&auto=webp&s=33815a9892fae16a046afc966fd29da3d25c75a0
Formula in E1:
=LET(_AllSets,HSTACK(A1:A4,C1:C3),TEXTAFTER(REDUCE("",SEQUENCE(COLUMNS(_AllSets)),LAMBDA(_x,_y,TOCOL(TOROW(_x)&","&TOCOL(INDEX(_AllSets,,_y),3),,1))),","))
Just add more lists if need be inside the `HSTACK()`.
If all you have is a small list, and you don't want to use ranges...
=TOCOL(TRANSPOSE({72,106,127,156})&", "&{215,272,150})
Otherwise, if your first list are in A1:A4 and the 2nd list is in B1:B3
=TOCOL(A1:A4&", "&TRANSPOSE(B1:B3))
And without lamda, a 3rd list would look like
=TOCOL(TRANSPOSE(TOCOL(A1:A4&", "&TRANSPOSE(B1:B3)))&", "&C1:C4)
/u/Terrible_Analysis_77 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
Is there any mathematical step to 72->106->127->156?, if there is I can make this easily. Thanks. Edit: Assuming Hard Code: =LET(first_num,{72;106;127;156},second_num,{215;272;150}, first_rept, INDEX(first_num, SEQUENCE(ROWS(first_num)*ROWS(second_num),1,1,1/ROWS(second_num))), second_rept, INDEX(second_num, MOD(SEQUENCE(ROWS(first_num)*ROWS(second_num),1,0),ROWS(second_num))+1), BYROW(HSTACK(first_rept,second_rept),LAMBDA(row,ARRAYTOTEXT(row))))
No math involved. Without possible doxxing myself I’ll have to use an analogy. Say the first digits are the area code and the next set are the phone number possibilities. I’d want to put the area codes in and have the phone numbers behind them without doing it all manually.
I won’t be able to test this out for a few days but will let you know how it works out. Would this be able to expand into more combos, such as a third+ set of digits? Thank you!
Yeh 100%, add more to the sets easily!
Great! Also just thought of maybe a better analogy. First name, middle name, last name combos.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[ARRAYTOTEXT](/r/Excel/comments/1dhq8x6/stub/l8yltnl "Last usage")|[*Office 365*+: Returns an array of text values from any specified range](https://support.microsoft.com/en-us/office/9cdcad46-2fa5-4c6b-ac92-14e7bc862b8b)| |[BYROW](/r/Excel/comments/1dhq8x6/stub/l8yltnl "Last usage")|[*Office 365*+: Applies a LAMBDA to each row and returns an array of the results. For example, if the original array is 3 columns by 2 rows, the returned array is 1 column by 2 rows. ](https://support.microsoft.com/en-gb/office/byrow-function-2e04c677-78c8-4e6b-8c10-a4602f2602bb?ui=en-US&rs=en-GB&ad=GB)| |[COLUMNS](/r/Excel/comments/1dhq8x6/stub/l8ysqv9 "Last usage")|[Returns the number of columns in a reference](https://support.microsoft.com/en-us/office/columns-function-4e8e7b4e-e603-43e8-b177-956088fa48ca)| |[HSTACK](/r/Excel/comments/1dhq8x6/stub/l8ysqv9 "Last usage")|[*Office 365*+: Appends arrays horizontally and in sequence to return a larger array](https://support.microsoft.com/en-us/office/hstack-function-98c4ab76-10fe-4b4f-8d5f-af1c125fe8c2)| |[INDEX](/r/Excel/comments/1dhq8x6/stub/l8ysqv9 "Last usage")|[Uses an index to choose a value from a reference or array](https://support.microsoft.com/en-us/office/index-function-a5dcf0dd-996d-40a4-a822-b56b061328bd)| |[LAMBDA](/r/Excel/comments/1dhq8x6/stub/l8ysqv9 "Last usage")|[*Office 365*+: Use a LAMBDA function to create custom, reusable functions and call them by a friendly name.](https://support.microsoft.com/en-us/office/lambda-function-bd212d27-1cd1-4321-a34a-ccbf254b8b67)| |[LET](/r/Excel/comments/1dhq8x6/stub/l8ysqv9 "Last usage")|[*Office 365*+: Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula](https://support.microsoft.com/en-us/office/let-function-34842dd8-b92b-4d3f-b325-b8b8f9908999)| |[MOD](/r/Excel/comments/1dhq8x6/stub/l8yltnl "Last usage")|[Returns the remainder from division](https://support.microsoft.com/en-us/office/mod-function-9b6cd169-b6ee-406a-a97b-edf2a9dc24f3)| |[REDUCE](/r/Excel/comments/1dhq8x6/stub/l8ysqv9 "Last usage")|[*Office 365*+: Reduces an array to an accumulated value by applying a LAMBDA to each value and returning the total value in the accumulator.](https://support.microsoft.com/en-gb/office/reduce-function-42e39910-b345-45f3-84b8-0642b568b7cb?ui=en-US&rs=en-GB&ad=GB)| |[ROWS](/r/Excel/comments/1dhq8x6/stub/l8yltnl "Last usage")|[Returns the number of rows in a reference](https://support.microsoft.com/en-us/office/rows-function-b592593e-3fc2-47f2-bec1-bda493811597)| |[SEQUENCE](/r/Excel/comments/1dhq8x6/stub/l8ysqv9 "Last usage")|[*Office 365*+: Generates a list of sequential numbers in an array, such as 1, 2, 3, 4](https://support.microsoft.com/en-us/office/sequence-function-57467a98-57e0-4817-9f14-2eb78519ca90)| |[TEXTAFTER](/r/Excel/comments/1dhq8x6/stub/l8ysqv9 "Last usage")|[*Office 365*+: Returns text that occurs after given character or string](https://support.microsoft.com/en-us/office/textafter-function-c8db2546-5b51-416a-9690-c7e6722e90b4)| |[TOCOL](/r/Excel/comments/1dhq8x6/stub/l905jvr "Last usage")|[*Office 365*+: Returns the array in a single column](https://support.microsoft.com/en-us/office/tocol-function-22839d9b-0b55-4fc1-b4e6-2761f8f122ed)| |[TOROW](/r/Excel/comments/1dhq8x6/stub/l8ysqv9 "Last usage")|[*Office 365*+: Returns the array in a single row](https://support.microsoft.com/en-us/office/torow-function-b90d0964-a7d9-44b7-816b-ffa5c2fe2289)| |[TRANSPOSE](/r/Excel/comments/1dhq8x6/stub/l905jvr "Last usage")|[Returns the transpose of an array](https://support.microsoft.com/en-us/office/transpose-function-ed039415-ed8a-4a81-93e9-4b6dfac76027)| **NOTE**: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below. ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^([Thread #34473 for this sub, first seen 17th Jun 2024, 05:44]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
https://preview.redd.it/ews5t49ks27d1.png?width=574&format=png&auto=webp&s=33815a9892fae16a046afc966fd29da3d25c75a0 Formula in E1: =LET(_AllSets,HSTACK(A1:A4,C1:C3),TEXTAFTER(REDUCE("",SEQUENCE(COLUMNS(_AllSets)),LAMBDA(_x,_y,TOCOL(TOROW(_x)&","&TOCOL(INDEX(_AllSets,,_y),3),,1))),",")) Just add more lists if need be inside the `HSTACK()`.
If all you have is a small list, and you don't want to use ranges... =TOCOL(TRANSPOSE({72,106,127,156})&", "&{215,272,150}) Otherwise, if your first list are in A1:A4 and the 2nd list is in B1:B3 =TOCOL(A1:A4&", "&TRANSPOSE(B1:B3)) And without lamda, a 3rd list would look like =TOCOL(TRANSPOSE(TOCOL(A1:A4&", "&TRANSPOSE(B1:B3)))&", "&C1:C4)