If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Restructuring records into a list
Hello,
I currently have a long series of records in the structure Descriptor Value ABC 123 DEF 456 GHI 789 ABC 321 DEF 654 GHI 987 I am trying to make a table from these in the form ABC DEF GHI 123 456 789 321 654 987 I thought I had it made with an OFFSET function, but I have the problem that some records have multiple lines of the same descriptor and some records have blank rows. For example, one record may have the form ABC 123 DEF 234 DEF 345 GHI 987 or ABC 123 DEF 234 GHI 987 But in every case the records start and end with the same descriptor. I'm guessing this is best done in a multistep method to combine the multiple rows (make a DEF 234345) and eliminate the balnk rows, but I am not making any progress. I've learned a lot from this group and really hope someone out there has some suggestions.... Thanks! Aaron |
#2
|
|||
|
|||
Restructuring records into a list
try a pivot table or transpose
" wrote: Hello, I currently have a long series of records in the structure Descriptor Value ABC 123 DEF 456 GHI 789 ABC 321 DEF 654 GHI 987 I am trying to make a table from these in the form ABC DEF GHI 123 456 789 321 654 987 I thought I had it made with an OFFSET function, but I have the problem that some records have multiple lines of the same descriptor and some records have blank rows. For example, one record may have the form ABC 123 DEF 234 DEF 345 GHI 987 or ABC 123 DEF 234 GHI 987 But in every case the records start and end with the same descriptor. I'm guessing this is best done in a multistep method to combine the multiple rows (make a DEF 234345) and eliminate the balnk rows, but I am not making any progress. I've learned a lot from this group and really hope someone out there has some suggestions.... Thanks! Aaron |
#3
|
|||
|
|||
Restructuring records into a list
add heading to your data and:
add one more column an put there formula: count.if($B$2:B2;B2) paste it down then create pivot table should work mcg |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
using first list box to populate choices in second list box | Giz | Using Forms | 2 | October 25th, 2005 04:51 PM |
Duplicate records in a mailing list? | kre8tor | New Users | 6 | August 8th, 2005 04:56 PM |
Query to List Records in Table 1 where fields match Table 2 | MHenry | General Discussion | 2 | November 30th, 2004 05:53 PM |
How can I update records by moving them up or down in a list? | jmcandrew | Using Forms | 2 | August 10th, 2004 07:19 PM |
selecting multiple records | sps | Using Forms | 3 | August 3rd, 2004 08:22 PM |