Hello,
I am enclosing a secondary sheet with more rows for you to review. I notices some data is still incorrect with your formulas.
https://www.dropbox.com/s/2k869wjzuhv0tzl/AmendedMessyData-2.xlsm?dl=0
if you look at your (referenceTheData) sheet. Scroll down on column B row 897 you will see an incorrect entry. And many more below that.
If there a way to modify what you have done to fill one row and allow me to FILL DOWN your formulas to accommodate the qty of rows per sheet. The amount of Attributes vary as well. Some sheets will have a few and max out at 50 total.
I had to modify the ref sheet to insert columns to line up the Attributes and Labels.
This is an amazing help and greatly appreciated.
thanks again,
Tino
Hi Tino
if you look at your (referenceTheData) sheet. Scroll down on column B row 897 you will see an incorrect entry.
1. Could you please take a look at this - and you will find the isn't a problem.
If you look at your original data you will see the routine has simply copied what is there.
The REFERENCE SHEET is "exactly what it says on the tin", as they say.
ALL it is.. is your original source data split (two columns kept together at a time) and pasted one below the other...
e.g.
| A | B | C | D | E | F |
| 1 | Label A1 | CodeB1 | Label C1 | CodeD1 | Label E1 | CodeF1 |
| 2 | Label A2 | CodeB2 | Label C2 | CodeD2 | Label E2 | CodeF2 |
| 3 | Label A3 | CodeB3 | Label C3 | CodeD3 | Label E3 | CodeF3 |
<tbody>
</tbody>
Copied so that it looks like this:
| A | B |
| 1 | Label A1 | CodeB1 |
| 2 | Label A2 | CodeB2 |
| 3 | Label A3 | CodeB3 |
| 4 | Label C1 | CodeD1 |
| 5 | Label C2 | CodeD2 |
| 6 | Label C3 | CodeD3 |
| 7 | Label E1 | CodeF1 |
| 8 | Label E2 | CodeF2 |
| 9 | Label E3 | CodeF3 |
<tbody>
</tbody>
And many more below that.
Now you can see this, you'll also be able to see that
whatever is below the cell you mentioned is EXACTLY the same as what's in your table.
No "processing" has been done on it at this stage... it's literally JUST the data in your table split up into it's component parts, and copied DOWNWARDS!
If there a way to modify what you have done to fill one row and allow me to FILL DOWN your formulas to accommodate the qty of rows per sheet. The amount of Attributes vary as well. Some sheets will have a few and max out at 50 total.
I had to modify the ref sheet to insert columns to line up the Attributes and Labels.
Now you understand this, you'll get that there is no need (on this sheet, at least) to "copy down formulas" because there aren't any...
It's simply your original data ...
structured differently.
Again... NO processing / formulae / etc has been done on it at that stage.
OK - I've looked at the spreadsheet you returned, and it's not the LASTEST version of the sheet I gave you.
If you look back through these posts, you'll see a LINK to a spreadsheet that does ALL that you need it to.
That post also describes that the data output you want is in the SECOND output table.
AND: You say you have many tables (I think you said 300) - you can paste data of any number of columns (can go far to the right >>>) and any number of rows (can go far down VVV ) and still process it.
Of course, there is a limitation, but I doubt you'll meet it (you'd need thousands of rows in your source data and many columns before Excel reaches it's limit of MAX ROWS).
Hope that helps clear things up?
