Consolidating Rows if certain criteria is met

**Corde** · #1 July 3rd 12, 06:36 PM

I'm trying to make this Excel document but I want the AdminTimes for the same LastRxNo to be on the same line. So if the LastRxNo is the same, have one line and the AdminTime column will have multiple values. Here is a picture of what I want it to look like

Any ideas? Thanks

**Corde** · #2 July 6th 12, 06:15 PM

Does anybody have any ideas? Would it help if I posted the SQL script used to create it?

I think there is a way to do that using a SQL script, but I'm not sure.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Consolidating and totaling rows into single row	Jon in the U&L	Excel Discussion (Misc queries)	12	March 11th 10 11:31 PM
Consolidating Data from Columns into Rows	Mike	Excel Discussion (Misc queries)	2	July 28th 09 07:17 PM
Consolidating Rows	Cow Girl	Excel Discussion (Misc queries)	0	July 22nd 09 04:25 PM
Compare and consolidating duplicated rows	Jen	Excel Discussion (Misc queries)	24	March 4th 08 08:49 PM
Consolidating Rows	Jason	Excel Discussion (Misc queries)	2	July 26th 06 02:37 AM