![]() |
#1
|
|||
|
|||
![]() How do I group the cells by the P, C, and T columns. When I group the C's together it adds it to the P columns. I want it to be a separate grouping |
#2
|
|||
|
|||
![]()
I assume in columns P#, C#, and T# are stored some values?
My advice is to use the structure like EmpNo, EmpName; WhateverDataID, Value where WhateverDataID contains e.g. P#, C#, or T#, and in Vlaue column is the value for this WhateverDataID. This allows you to group easily your data in any way you want. And when you like your current setup when looking at your data, simply create a report sheet, which reads data from entry sheet, and displays it in any format you like. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Code to delete selected columns and re arrange columns in order | RAJESH@1960 | Excel Programming | 1 | 04-14-2023 07:58 AM |
Grouping {MERGEFIELD} into 2 or 3 Columns | BNDCK | Mail Merge | 1 | 08-03-2021 01:07 AM |
Split selected columns, or all columns exept for Column1 | Cendrinne | Word VBA | 2 | 09-20-2019 09:14 PM |
![]() |
differentdrummer | Excel | 3 | 12-10-2013 01:19 AM |
![]() |
Learner7 | Excel | 5 | 06-12-2010 09:54 AM |