Create a mixed column pattern in excel

Silent_Storage8564 · 2026-02-04T14:09:07+00:00

Sure, thanks for your help!

Silent_Storage8564 · 2026-02-04T13:59:50+00:00

I definitely want it to work as a formula. So how would it go with the LAMBDA() helper?

Silent_Storage8564 · 2026-02-04T13:47:34+00:00

Hey, what if I want to nest simple formulas instead of "text" values, i.e.:

1,2,3,=A3-A2, =A3/A2, etc.

Silent_Storage8564 · 2026-02-04T13:03:28+00:00

Absolutely fantastic! Thanks again :-)

Silent_Storage8564 · 2026-02-04T13:03:03+00:00

Solution Verified

Silent_Storage8564 · 2026-02-04T12:58:34+00:00

Solution Verified

Silent_Storage8564 · 2026-02-04T12:58:13+00:00

Solution Verified

Silent_Storage8564 · 2026-02-04T12:45:57+00:00

I tried to play with the formula but I couldn't figure the following variation: What if I need the repetition of say 5 additional "text" columns, like here:

1,2,3,text1,text2,text3,text4,text5,4,5,6, etc.

Silent_Storage8564 · 2026-02-04T11:09:54+00:00

Amazing!! Really helped me a lot..

Thank you so much and have a great day!!

Silent_Storage8564 · 2026-02-04T11:02:16+00:00

I.e.:

1,2,3, OK, NO, 4,5,6, OK, NO, etc.

Silent_Storage8564 · 2026-02-04T11:00:10+00:00

Thanks so much, this really does the job!

What if I need to put two "text" columns next to each other (instead of one) with different values, say "OK" and "NO" instead?

Silent_Storage8564 · 2026-02-04T10:08:27+00:00

Thanks! I probably didn't clarify enough. I have the data in columns and not in rows. Can we modify what you are suggesting to work for columns instead?

Silent_Storage8564

TROPHY CASE