Transpose a long column into delimiters separated values according to values in input box

**prkhan56** · 12-25-2014, 05:27 AM

Thanks everybody.
Happy New Year!!

**nilem** · 12-25-2014, 06:02 AM

Hi Rashid,
try this

Please Login or Register  to view this content.

**jindon** · 12-25-2014, 06:09 AM

Please Login or Register  to view this content.

**Rioran** · 12-25-2014, 06:14 AM

Hello, Rashid!

Check my solution in the attachment. May it be what you need?

Please Login or Register  to view this content.

**Rioran** · 12-25-2014, 06:20 AM

Hello, Nilem!

Nice code, but it produces unneeded delimiters if row is not full. With ";" delimiter and j = 10 I received final row as shown below:

Please Login or Register  to view this content.

**nilem** · 12-25-2014, 10:34 AM

@ Rioran
Hi Roman,
yes, you're right, so try this

Please Login or Register  to view this content.

or maybe this

Please Login or Register  to view this content.

Thanks and Merry Christmas

**prkhan56** · 12-27-2014, 01:32 PM

Works like a charm!
Thanks a lot to all of you.
Wish you all a Happy and Prosperous New Year!!!!

Rashid

Re: Transpose a long column into delimiters separated values according to values in input