LinkBack URL
About LinkBacks
I have 5 rows for each entry I have. I need to take these 5 rows and move to 5 colums for each entry.
Data now:
CN
DBAN
MA1
MA2
CSZ
I would like to have:
CN DBAN MA1 MA2 CSZ
I have 5 rows for each entry I have. I need to take these 5 rows and move to 5 colums for each entry.
Data now:
CN
DBAN
MA1
MA2
CSZ
I would like to have:
CN DBAN MA1 MA2 CSZ
Copy the range, EDIT|PASTE SPECIAL and select Transpose.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
I have an entire column of entries.
Example:
1CN
1DBAN
1MA1
1MA2
1CSZ
2CN
2DBAN
2MA1
2MA2
2CSZ
3CN
3DBAN
3MA1
3MA2
3CSZ
See if example helps using
VBA Noob=OFFSET($A$1,COLUMN(A1)-1,ROW(A1)-1)
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks