Notifications
Clear all
Topic starter
hi.. is there formula to do this..
thankyou very much
Posted : 21/05/2025 2:51 am
I would do that with Power Query as demonstrated in the attached file.
Edit: Thought of a formula solution as well. Enter the formula below anywhere in the file.
=TEXTSPLIT(
TEXTJOIN(
"-",
TRUE,
REPT(
Table1[Column2] & "-",
Table1[Column1]
)
),
,
"-",
TRUE
)
Posted : 21/05/2025 3:12 pm
Topic starter
hi... nice.. thankyou verymuch for your help...
regards,
Posted : 22/05/2025 11:48 pm
Hi Riny,
this formula can work in 2019 ver
Posted : 24/05/2025 4:18 pm
i have tried Textjoin, possible any split function in 2019 or any other way
Posted : 28/05/2025 2:01 pm
Can't think of a formula without TEXTSPLIT. I would opt for the Power Query solution, as it's very easy.
Posted : 28/05/2025 2:30 pm
ok thanks i will try my side
Posted : 30/05/2025 7:41 pm
