Data Table - how to rearrange dataset?

[spider_min]

Hello,

How to convert the dataset below to the way that I can Pivot?

DataSet
name2 value
userid 101
userlogin admin
firstname The
surname Administrator
userid 102
userlogin John.Doe
firstname John
surname Doe
userid 104
userlogin Jane.Dee
firstname Jane
surname Dee


Convert the above to below:
userid userlogin firstname surname
101 admin The Administrator
102 John.Doe John Doe
104 Jane.Dee Jane Dee

Thanks!

+Attached sample dataset

[BadlySpelledBuoy]

Could you post your sample data in a workbook showing before and after?
It loses it's formatting when you paste it into a forum post like that so not 100% clear what it looks like originally or the expected result.

BSB

[spider_min]

I've attached a dataset.

[dosydos]

if your data is always going to be 3 rows per dataset (ex. ID,First,Last) then 3 simple offset formulas can get the job done, then drag all three formulas down for rest of data.

ID

Please Login or Register  to view this content.

First

Please Login or Register  to view this content.

Last

Please Login or Register  to view this content.

[spider_min]

Hi dosydos,

How can I modify the code if there are more than 3 rows per dataset?

[JohnTopley]

=INDEX($B$3:$B$14,(ROWS($1:1)-1)*3+COLUMN(A1))

copy across and down