ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I group record w/same info but different number in a row (https://www.excelbanter.com/excel-discussion-misc-queries/28587-how-do-i-group-record-w-same-info-but-different-number-row.html)

Lotus123

How do I group record w/same info but different number in a row
 
How do I group a record with same info but different number in a row.
Example below:
ID, lname, fname, dob, fallqty,
ID, lname, fname, dob, springqty

How do I write the code to put the column "springqty" on the same line with
the "fallqty" and group the rest of the info since they are all the same(ID,
lname, fname, dob)?


All times are GMT +1. The time now is 03:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com