Morning/Afternoon all,

New to the Offset function and unsure whether it is the right one to use but am trying to change a long list of metadata (80,000+) to show in Columns instead of Rows. An example of the text I am trying to re-arrange is below:-

Comment: Santosh Gaddu, Manchester
Creation time: 23/05/07 10:44:40
Logon times: From Sunday,00:00:00 to Saturday,23:59:00
Last successful logon time: 23/02/09 09:10:08
10.249.82.33
Logon tally: 318
Maximum concurrent sessions: 10
Comment: Emma Finnigan Chester
Creation time: 12/11/03 17:07:58
Logon times: From Sunday,00:00:00 to Saturday,23:59:00
Last successful logon time: 17/03/05 10:06:26
10.86.158.63
Logon tally: 91
Maximum concurrent sessions: 10
Comment: Rossella Richardson, Manchester
Creation time: 14/05/07 14:09:15
Logon times: From Sunday,00:00:00 to Saturday,23:59:00
Last successful logon time: 23/02/09 12:02:58
10.249.82.39
Logon tally: 284
Maximum concurrent sessions: 10

I know I could use Transpose but would have to do this one by one. I have 7 rows that I wish to change to coloumns for 10k+ people. Any ideas how I could go about this?

Cheers guys,

Craig.