Transposing data from multiple rows into single rows & multiple columns
Just joined the community, so forgive me if I failed to understand any of the forum rules.
My current spreadsheet has 2 columns:
A contains Record Numbers
B contains Code
There are duplicate rows for Record Numbers with multiple code entries without any consistency. One Record Number can have as many as 30 codes (and rows), or as few as one.
I need to somehow collapse those multiple rows into a single row, simultaneously taking the Code entries from column B and aligning them horizontally across multiple cells.
A B C D E F
Record Code Code2 Code3 Code4
0001 AQ AW
0003 AR AT AW FD FS
0004 AT AX AR
Thanks in advance!
Last edited by VBA Noob; 03-18-2009 at 04:20 PM.
Re: Transposing data from multiple rows into single rows & multiple columns
Try the attached workbook
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1