Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping data across rows
Hi!
I am struggling to find an elegant soution to my problem: I have a list of equipment tags, with info associated to each tag. I need to provide electrical hookup info to my tags. This info consist of a lead colour and a post number for each lead. Each tag can have any number of leads, in any combination three colours. Is there a way for me to automate the following: I enter my tag number and general info in a list like I do now. In one of the columns I have my hookup info for that tag, like BLUE 1- BROWN 2-BLACK 3-BLUE 4-BROWN 5. I would like to be able to present this data in the following table form: _____________BL______BR_____BK TAG__________1 ______________________2 _____________________________3 ______________4 ______________________5 Or is there any other elegant way of presenting this data in an easy to read form? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
grouping rows... | New Users to Excel | |||
Empty rows after grouping | Excel Discussion (Misc queries) | |||
Grouping Rows | Excel Discussion (Misc queries) | |||
Grouping According to Sets of Rows | Excel Worksheet Functions | |||
Grouping rows together | Excel Worksheet Functions |