Need an Excel Guru

[Bob Kontak]

Originally Posted by M.D. Holloway

I know it can be down. I remember in grad school with a very old version I did macros to do something like this. It must be simpler now. I just never mess with it.

There is a function where you can take column data and convert to rows.

Happy for you to e-mail me. We can talk on the phone and I can more than likely pull it off for you.

If it's an onerous set of data, I can get a handle on what you need. Perform some due diligence to ensure it can be done and teach you.

If it's a couple hour job, I can do it.

23 years as an operational accountant.

Paul T sounds viable as well.

Will PM you my e-mail.

[72doug2,2S]

You can do this on this thread and get several options to do the same thing. What I would want to know is what is the most efficient solution. No reason to PM.

[Bob Kontak]

Originally Posted by 72doug2,2S

You can do this on this thread and get several options to do the same thing. What I would want to know is what is the most efficient solution. No reason to PM.

Ok. Once the speed bump is articulated, fine.

Here is what you have to go on.

Originally Posted by M.D. Holloway

The data in the rows has to parse to the date of the other spread sheet columns.

This means the data in the rows has to be parsed to allow linkage to the sister spreadsheets. You know that. Data still has to be linked, the hard way.

We don't have (understand) the basis for doing that yet.

[MBAtarga]

My solution involved use of vlookup. I sent the revised file back to him for him to look at - it was only a partial solution - I didn't complete the spreadsheet because the data was not consistent in terms of labels between the files. He basically needs a table of raw data - where each new set of measurements that is added as another column on the right, converted to be rows of data under columns on another spreadsheet.

[Bob Kontak]

Originally Posted by MBAtarga

I didn't complete the spreadsheet because the data was not consistent in terms of labels between the files.

If you can work vlookup today, you are seven years ahead of me. Function is the same. I am just rusty.

How inconsistent is the data?

[M.D. Holloway]

Mark,
Sorry I didn't respond sooner. This is exactly what I'm looking for! I can provide a spread sheet map if you will where cells in one equal cells in another if that helps? I will look to get on it in the PM tomorrow.

[72doug2,2S]

Lubey, why not post the screen shots?

[Amail]

Be careful with hlookup and vlookup guys. Data needs to be sorted in ascending order which sometimes is inconvenient. Index-match is the method I use these days - see Say Goodbye to VLOOKUP, and Hello to INDEX-MATCH | eImagine Technology Group for a good explanation.

[72doug2,2S]

You also can't use multiple criteria with h/vlookups

[Drbraunsr]

Array formulas are voodoo