Database in Columns need rows

you could always copy -> paste special -> transpose.

or are you looking for a formula based approach??

I tried to do that but a had no luck. There are 1500 rows of data and it did not match.

Maybe I did something wrong????

Hopper said:

I tried to do that but a had no luck. There are 1500 rows of data and it did not match.

Maybe I did something wrong????

Click to expand...

this being the case, your original post may be a little ambiguous as to what you are trying to accomplish. can you post a little more information on what you are trying to accomplish?

There are only 256 columns in Excel, you would have to split it up somehow
Paul
:wink:

Ok -
The example I posted is just one record. There are 440 records each with 8 fields. The first column is the record number, the second column is the field number and then the third column is the actual data

Does this make sense?

Sorry for confusion.

Hopper!

Disregard my previous post:

If the next set of records starts on A9 and goes down this will work.

The following will be in Sheet2! of the same workbook:

in A1 =INDIRECT(ADDRESS(ROW(Sheet1!A1)+J1,COLUMN(Sheet1!A1),,,"sheet1"))

in B1 =INDIRECT(ADDRESS(ROW(Sheet1!C1)+J1,COLUMN(Sheet1!C1),,,"sheet1"))

in C1 =INDIRECT(ADDRESS(ROW(Sheet1!C2)+J1,COLUMN(Sheet1!C2),,,"sheet1"))

in D1 =INDIRECT(ADDRESS(ROW(Sheet1!C3)+J1,COLUMN(Sheet1!C3),,,"sheet1"))

in E1 =INDIRECT(ADDRESS(ROW(Sheet1!C4)+J1,COLUMN(Sheet1!C4),,,"sheet1"))

in F1 =INDIRECT(ADDRESS(ROW(Sheet1!C5)+J1,COLUMN(Sheet1!C5),,,"sheet1"))

in G1 =INDIRECT(ADDRESS(ROW(Sheet1!C6)+J1,COLUMN(Sheet1!C6),,,"sheet1"))

in H1 =INDIRECT(ADDRESS(ROW(Sheet1!C7)+J1,COLUMN(Sheet1!C7),,,"sheet1"))

in I1 =INDIRECT(ADDRESS(ROW(Sheet1!C8)+J1,COLUMN(Sheet1!C8),,,"sheet1"))

Then select A1 thru I1 and drag down as far as needed.

For this to work you have to have 0 in J1, 7 in J2, 14 in J3, ... just series fill these down as far as needed (with 0 in J1 and 7 in J2, highlight both and drag down as far as needed with fill handle)


Paul

Hopper said:

Ok -
The example I posted is just one record. There are 440 records each with 8 fields. The first column is the record number, the second column is the field number and then the third column is the actual data

Does this make sense?

Sorry for confusion.

Hopper!

Click to expand...

Hi Hopper:

From what you have posted, the data forms one record in the new format -- just to be clear about what your data looks like, how about if you post the data what would constitute record number 2, 3, and so on.

Pictures to go with my post above

and Sheet2

Paul

Hi Paul:

That is what I had thought what Hopper's data would look like -- but I wanted Hopper to confirm it -- to alleviate ambiguity -- althouh the confusion had been alleviated earlier!