Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Move Data from rows to columns...
Hi,
I have contact information, name, address etc all in column A. Each group is separated by a row with a 0 in it. I need to transpose it to columns. Thanks to Biff's help in a previous post, I have this formula to do this: =INDEX(Sheet1!$B:$B,(ROWS($1:1)-1)*7+COLUMNS($A:A)) The problem is that some of the groups have 4 rows of data, some have 8 and others somewhere in between. Plus the row with the 0 between each group throws stuff off too. So what can be added to this formula to accomplish this. Thanks!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Move Data from rows to columns...
Hi!
If the data sets have different numbers of entries then there is no easy way to do this that isn't labor intensive. About the only thing I can think of would be to insert empty rows between data sets so that there is a uniform pattern. The number of rows between the first entry of each set would need to be the same then you could just adjust this portion of the formula: *7 Biff "Dan B" wrote in message ... Hi, I have contact information, name, address etc all in column A. Each group is separated by a row with a 0 in it. I need to transpose it to columns. Thanks to Biff's help in a previous post, I have this formula to do this: =INDEX(Sheet1!$B:$B,(ROWS($1:1)-1)*7+COLUMNS($A:A)) The problem is that some of the groups have 4 rows of data, some have 8 and others somewhere in between. Plus the row with the 0 between each group throws stuff off too. So what can be added to this formula to accomplish this. Thanks!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Move Data from rows to columns...
Thanks for your help, it did help a lot!. I'll see what I can do with it
the rest of the way. "Biff" wrote in message ... Hi! If the data sets have different numbers of entries then there is no easy way to do this that isn't labor intensive. About the only thing I can think of would be to insert empty rows between data sets so that there is a uniform pattern. The number of rows between the first entry of each set would need to be the same then you could just adjust this portion of the formula: *7 Biff "Dan B" wrote in message ... Hi, I have contact information, name, address etc all in column A. Each group is separated by a row with a 0 in it. I need to transpose it to columns. Thanks to Biff's help in a previous post, I have this formula to do this: =INDEX(Sheet1!$B:$B,(ROWS($1:1)-1)*7+COLUMNS($A:A)) The problem is that some of the groups have 4 rows of data, some have 8 and others somewhere in between. Plus the row with the 0 between each group throws stuff off too. So what can be added to this formula to accomplish this. Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to merge rows of data in 2 columns into 1 col. | New Users to Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Dealing with data in several columns AND rows | Excel Discussion (Misc queries) | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Finding common data in multiple columns and rows in Excel | Excel Worksheet Functions |