data movement

[greavesa]

Hello, I have just joined & in need of help.

I have been provided with a spreadsheet of 750 questions (3500 rows) which I need to change the layout to. I think there must be a quick way but I don't know it.

What I have done is attached a copy of what I have & what I would like.

Can anyone help.

Thanks in advance

Greavesa

[DOES]

Hello, I have just joined & in need of help.

I have been provided with a spreadsheet of 750 questions (3500 rows) which I need to change the layout to. I think there must be a quick way but I don't know it.

What I have done is attached a copy of what I have & what I would like.

Can anyone help.

Thanks in advance

Greavesa

Hi greavesa! Welcome to the great forum!

You can make use of this function TRANSPOSE to re-layout the spreadsheet by making horizontal lines into vertical ones.

Please Login or Register  to view this content.