Transposing data

Hello all,

I have a report that I need the data to be moved from two columns to their own columns. The first column has the field names as you can see. Column B has variable data that corresponds to the respective field name. The space between the below column is for your benefit. There is no delimiter between them. I could add one if needed.

SamAcntName
GivenName
Surname
DisplayName
Description
Location
AccntPword
EmployeeType
Path
Script
AccntExpiration
UDrivePath
ManagerUserID

SamAcntName
GivenName
Surname
DisplayName
Description
Location
AccntPword
EmployeeType
Path
Script
AccntExpiration
UDrivePath
ManagerUserID


WHat I want is:
SamAcntName GivenName Surname etc.....
userid1 Jake Bleh
userid2 MoMo Fleh

I could swear up and down that this a pivot table issue, but I have tried to create the pivot table with no results.

Hello Lonesoac0,

I don't see any Column B values in your post. Both columns are the same. However, below is some code which I think will do as you would like:-

Please Login or Register  to view this content.

I've attached my test work book for you to play with. Click on the "RUN" button to see it work.

I've just made up some Column B values in the sample.

I hope that this helps.

Cheerio,
vcoolio.

First, thank you for your response. Here is a better representation of my report.

SamAcntName sdfsdfsdf
GivenName sf
Surname sfsdvsvsdv
DisplayName svdsvdsvsdv
Description svsdvsdvsvdsvsdsd
Location svdsd
AccntPword sdvsdvdsv
EmployeeType svsdsvsvdvdsvv
Path svsdvvsdvsdvsdvs
Script svdsvsvds
AccntExpiration svsdvsdvsdv
UDrivePath svsdvsvsvsvsvdvs
ManagerUserID svsdvsdvsvsds
SamAcntName svsdvsdvsdv
GivenName svsdvdsv
Surname ssdvsd
DisplayName svdsdvsdvsdvsv
Description svdssvsdsvsdvs
Location sdfsdfsdf
AccntPword sf
EmployeeType sfsdvsvsdv
Path svdsvdsvsdv
Script svsdvsdvsvdsvsdsd
AccntExpiration svdsd
UDrivePath sdvsdvdsv
ManagerUserID svsdsvsvdvdsvv
SamAcntName svsdvvsdvsdvsdvs
GivenName svdsvsvds
Surname svsdvsdvsdv
DisplayName svsdvsvsvsvsvdvs
Description svsdvsdvsvsds
Location svsdvsdvsdv
AccntPword svsdvdsv
EmployeeType ssdvsd
Path svdsdvsdvsdvsv
Script svdssvsdsvsdvs
AccntExpiration svsdsvsvdvdsvv
UDrivePath svsdvvsdvsdvsdvs
ManagerUserID svdsvsvds
SamAcntName svsdvsdvsdv
GivenName svsdvsvsvsvsvdvs
Surname svsdvsdvsvsds
DisplayName svsdvsdvsdv
Description svsdvsvsvsvsvdvs
Location svsdvsdvsvsds
AccntPword svsdvsdvsdv
EmployeeType svsdvdsv
Path ssdvsd
Script svdsdvsdvsdvsv
AccntExpiration svdssvsdsvsdvs
UDrivePath svsdsvsvdvdsvv
ManagerUserID svsdvvsdvsdvsdvs


I want:

GivenName Surname DispalyName etc.
sdfsdfsdf aasacaca ascascas
sdfsfdsdfssf acascac ascascsac
sdsdfsdd acascascasc acacsascsac
sfdsfssvs ascacac asdascsac

Sorry for not specifying more.

Try

Please Login or Register  to view this content.

Thank you all for your support on this issue. I KNEW there was a way to naively do what I wanted, I just had no idea how to do it. I was looking into PowerQuery and everything. I definitely plan on using both answers in different situations.

Thank you both!

I am not going to lie, I went straight into work to test this out. It works like a charm!

You are welcome and thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.