Need help Moving Data from Rows to Columns with Differing Row Amounts Between Data

**Fpob** · 02-06-2012, 02:21 PM

Hi all,

It's been a while since my first posts. I'm in need of help again and figured I'd come back to the place that really saved me last time.

Here's the dilemma:
I have over 78,000 rows of information that I want to take and transpose into columns. However, there are a different amount of rows between each section of data.

For example: All the data in one section pertains to a school. However, some of the schools have more or fewer rows; i.e. not all schools have 388 rows, some have 391, some have 385.

In the past, when these sections have the same amount of rows, I've used:
=INDEX(Raw_Data!$J:$J,3+INT(ROWS(A$2:A2)*388))

Any suggestions??

**Pete_UK** · 02-06-2012, 02:43 PM

You can use a helper column to try to identify the start of each record and thus set up a sequential number for each record. You will need to post an example of your data showing a few records (plus the last one, in case there are footers that need to be accounted for), then we can see if there is anything to denote the start of a record (e.g. a blank row between records).

Hope this helps.

Pete

**Fpob** · 02-06-2012, 08:21 PM

Ok, so I worked something out to get this formula:

=IF(Raw_Data!C10=Raw_Data!B10&"_"&J$3,Raw_Data!L11,Master_Data!$B$2)

I now need to figure out how to increase the row values for certain references while dragging across columns.

So I need the formula I posted above to read:
=IF(Raw_Data!C11=Raw_Data!B11&"_"&K$3,Raw_Data!L12,Master_Data!$B$2)
when I drag it to the next column and so on and so forth.

Need help Moving Data from Rows to Columns with Differing Row Amounts Between Data

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Need help Moving Data from Rows to Columns with Differing Row Amounts Between Data

Re: Need help Moving Data from Rows to Columns with Differing Row Amounts Between Dat

Re: Need help Moving Data from Rows to Columns with Differing Row Amounts Between Dat

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions