Transposing multiple individual records Closed

Question

Hello,
I have data with each individual record split down multiple rows, followed by the next individual record. 
Each has a unique record # in Column A and something I need to sort by in Column C, identical for each individual record (but several possibilities across records), but then in column F each record's information is listed down multiple rows. 
Ideally I would sort first by column C then A, then what I have been doing is splitting the sorted info based on col. C into new wkshts. 
Then I manually highlight the multiple rows of Col. F for each unique record number in Col. A, and use the transpose function, then delete unneeded columns. 
I know there are more efficient ways excel can do at least parts if not all of this...
Thanks so much!

subzero00 · Answer

hi,
i have understood what you are saying but you have not asked any question.
please post your question.

Heather · Answer

Can I set up a macro to transpose this data in Column C into a single row and multiple columns (rather than one column and multiple rows) for each unique record number repeated in Column A for all the rows of data for that record.  For example:
25	Gender	Male
25	Choose	Without
25	Size	X
25	Waiver	Accept
25	Accept	Yes
25	Address	20 W Lane
25	City	Rimond
25	Email	test@gmail.com
25	First Name	Fran
25	Last Name	TestA
25	Phone	1111111111
25	Age	41
25	State	VT
25	Zip	11111
26	Gender	Female
26	Choose	Without
26	Size	M
26	Waiver	Accept
26	Accept	Yes
26	Address	400 South W Street 
26	City	Best
26	Email	test@gmail.com
26	First Name	Ellie
26	Last Name	TestB
26	Phone	1111111111
26	Age	34
26	State	VT
26	Zip	11111

In this example I would like the information in column c to be in two rows and 14 columns, each starting with the unique number in column A.  I can delete column b.  My actual data has many more records.  Thanks!

Transposing multiple individual records

2 responses

Similar discussions

Subscribe To Our Newsletter!