Twist Data?...

[Darran]

Hi all...

I've got the following in a dataset:

19 30 1200 FI FI 20030906 36
19 30 1324 FI FI 20030906 36

and I want the following result:

19 30 1200, 1324 FI FI 20030906 26

Any guess on how to do this?

thanks much!...

 

[Anders S]

Hmmm...

Not quite clear:

The data is arranged in columns, I assume

It looks as if both items in the same column are the same, you want just one
item, otherwise the one in the top row first, then the one from the bottom row.
But what about the last 36s that should yield 26? Typo?

Does the dataset have more columns or more rows or both? And how big is it? We
must consider worksheet dimension limits.

Anders Silvén