Convert data from multiple rows into columns?

February 16, 2011 at 07:38:25
Specs: Windows XP
I have a spreadsheet with multiple rows for each entry (propnum). I want to convert this into 1 row for each propnum with separate columns. Below is how my data currently looks (dump from Access):

PROPNUM KEYWORD EXPRESSION
D81JMJNDXT ENDDATE SEQ3156
D81JMJNDXT START SEQ3135 DELAY 1
D81JMJNDXT OIL 3000 1000 B/M 81.940 MB EXP X
D81JMJNDXT GAS/OIL 1.2 1.2 M/B TO LIFE LOG TIME
D81JRQMDST ENDDATE SEQ3166
D81JRQMDST START SEQ3156 DELAY 1
D81JRQMDST OIL 0 0 B/M TO LIFE EXP X


I want it to look like this:

PROPNUM ENDDATE START OIL GAS/OIL
D81JRQMDST SEQ3156 SEQ3135 DELAY 1 3000 1000 B/M 81.940 MB EXP X 1.2 1.2 M/B TO LIFE LOG TIME
D81JRQMDST SEQ3166 SEQ3156 DELAY 1 0 0 B/M TO LIFE EXP X


See More: Convert data from multiple rows into columns?

Report •


#1
February 18, 2011 at 21:47:48
Please read the How To referenced in my signature line so that your data will line up correctly. It will be easier to understand what you are looking to have done once we see the proper lay out your data.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question