Freezing first line columns to rows

Lauritsjust

Hi all

I am trying to "freeze" the first column and move other columns to a new row with the frozen column as an account identifier in the first line. 

My input looks something like this:

and I would like my output to look like this:

However, when I do it, it keeps putting the new rows in different columns instead of column 2-4.

Any suggestions? 

Columnstorows.yxmd

Ben_H

Hi @Lauritsjust,

This is the way I would approach it -

I transposed the data, and then removed the numbers from the field names (ISIN1,2,3), tidied up the data a little and then cross tabbed back to the format you want.

Sorry for the brief explaination, I'm short of time - It should be pretty easy to follow if you download the attachment.

Regards,

Ben

Columnstorows.yxmd