| 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!! |
| 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 | |||
Threaded Mode
