Tranpose column to rows with header

this is the raw data
wellname 101 date typeA tdepth bdepth
wellname 101 date typeB tdepth bdepth
wellname 102 date typeA tdepth bdepth
wellname 102 date typeB tdepth bdepth
wellname 102 date typeC tdepth bdepth
wellname 103 date typeB tdepth bdepth
wellname 103 date typeA tdepth bdepth
wellname 103 date typeA tdepth bdepth
wellname 103 date typeB tdepth bdepth
wellname 103 date typeC tdepth bdepth

this is what i would like to get
wellname 101
date typeA tdepth bdepth
date typeB tdepth bdepth
wellname 102
date typeA tdepth bdepth
date typeB tdepth bdepth
date typeC tdepth bdepth
wellname 103
date typeB tdepth bdepth
date typeA tdepth bdepth
date typeA tdepth bdepth
date typeB tdepth bdepth
date typeC tdepth bdepth

Any help would be appreciated

Hi
are you raw data in 6 adjacent columns, or a single string in cells in one column?

6 adjactent columns

sorry about that it's actually 5, wellname belongs to 101 and so on. thanks again for getting back so soon.

Hi
try this macro
you'll need to set InputRange as the address of the range data to transpose, and OutputCell as the first cell of the range to copy to
I have assumed you want date, type A etc in separate columns - let me know if you prefer it in a single string in one cell in the column

Please Login or Register  to view this content.

Hi
try this macro
you'll need to set InputRange as the address of the range data to transpose, and OutputCell as the first cell of the range to copy to
I have assumed you want date, type A etc in separate columns - let me know if you prefer it in a single string in one cell in the column

Please Login or Register  to view this content.

apologies for the duplicate post - my computer froze for a while